Excel Data copying from multiple sheets to a summary sheet by filter

I own a business in Austin [url removed, login to view] and have an excel workbook with about 15 spreadsheets in it. I need to copy line entries from these sheets to a summary sheet based on an entry in a column. In addition, when the filter letter is removed from the summary page I need it to drop off the summary page but remain on the main worksheet.


Amended Description:

I own a business in Austin www.geckohi.com and have an excel workbook with about 15 to 20 spreadsheets in it at any given time.

I manage my clients from excel spreadsheets. As I have new clients I add a spreadsheet to the workbook. As I have new entries from these clients I enter them as line items on the spreadsheet. These entries are scheduled at different times for technicians to complete. I need to be able to enter a date in a column and have the associated line post to a global summary page preferably in another workbook, but if that is not possible it can be in the same workbook. Then, as the technicians complete these items I need them to change the date to a c, or, even better, add a "c" in another column and have the entry become only viewable from the project worksheet and not the summary worksheet. I also need to be able to delete worksheets or archive them and easily add new clients / projects to a new template worksheet.

Can this even be done?

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Microsoft Access, tietojärjestelmäarkkitehtuuri

Näytä lisää: excel filter data multiple sheets, multiple sheets need summary, excel copy sheet multiple sheets, copy multiple sheets data summary sheet, data entry worksheet, sheets, line sheet, excel data sheet, data entry summary, data entry in excel sheets, copying, data entry worksheet excel, summary business, excel column copy, excel drop, summary data entry, business excel workbook, filter excel, excel filter, data filter, excel copy sheets, data copying excel, summary excel, excel summary, data entry excel worksheet

Tietoa työnantajasta:
( 0 arvostelua ) lakeway, United States

Projektin tunnus: #4250930

Myönnetty käyttäjälle:


Can do, assuming my assumption (please see attached PM) is correct.

$25 USD / tunti
(7 Arvostelua)

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


Hello, Pls have a look to your [url removed, login to view]

$25 USD / tunti
(233 arvostelua)

{{(((Please read PM for further details)))}} ...Thanks

$25 USD / tunti
(94 arvostelua)

Please check your inbox. Thanks

$25 USD / tunti
(47 arvostelua)

I have 15 years of excel experience.

$30 USD / tunti
(13 arvostelua)

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT/ Data Entry/ Web Research/Admin/SEO/ Co Lisää

$30 USD / tunti
(11 arvostelua)

Hi there, I m expert in Data administration work. Kindly read msg box....

$25 USD / tunti
(16 arvostelua)

Let's DO IT NOW! Quality, Speed, Precision guaranteed! Excel expert here. Thanks!

$25 USD / tunti
(11 arvostelua)

I am ready and confirm you to complete it [url removed, login to view] find the inbox for more details.

$30 USD / tunti
(14 arvostelua)

Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks

$25 USD / tunti
(12 arvostelua)

More than 10 years experience in Excel and Excel macro.

$26 USD / tunti
(6 arvostelua)

I got 7+yrs experience in Data collection,Bulk Email marketing and Internet research [url removed, login to view] PM. Thanks.

$25 USD / tunti
(1 arvostelu)

I am ready to start this project. thanks

$25 USD / tunti
(7 arvostelua)

I would like to get this opportunity to have this project..and fullfill your requirements with quality work...thankyou....

$25 USD / tunti
(0 arvostelua)