Hey all, hopefully you guys can help me out!
I run a small business with 8 employees who work at 6 various sites around the city. Their revenue is entered into an online database, but I also keep a copy in Excel (2007) for my own purposes. Here is an explanation of the spreadsheet.
First worksheet: A summary of all the data, such as totals, costs etc.
2nd worksheet: Inventory orders
3-8th worksheets: Record revenue for each of the 6 sites
Here is my issue.
My guys all move around site to site, so in each of those 3-8th worksheets I have recorded their name beside the revenue earned that day. Their names are recorded in cells B4:B217, revenue breakdown is recorded in Cells C-G4:217, and total revenue is in cell H4:H217.
On my summary sheet, I wish to use a function to search through those 6 workbooks for each employees name, and pull the revenue they earned that day into a single cell that totals it all.
I have successfully made a function that works for each cell, but doing that one function for 6*217 cells per employee seems a bit excessive.
Any ideas? Help would be greatly appreciated!
Bookmarks