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.
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?