Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I want to create a formula that will allow me to copy a weekly running total
of information from several sheets to one, but the information on each sheet is not in the same order, and some will not appear on each sheet. On each sheet I have titles of Employee Number and amount, but I want it to filter through so on the total page I have a list of Employees and a total for the week. I need it to recognise the employee number on the day sheets and know that I want the amounts to appear on the total sheet by this employee number. Does anybody know if this is possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |