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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
vlookup will look up the eployee number and display as many columns as you
want.Give us some exaples of how your data is laid out and what you want shown on your summary sheet -- paul remove nospam for email addy! "Stacey" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Hi Paul
The daily spreadsheets contain a list of the employees (in order of shift pattern) who worked that day (so not all employees)and what amount they made in tips. I need the total page to add up the tips for each employee, but on the total sheet all the employees are listed in employee number order. If you could let me know who to do this I would be very greatful Thanks Stacey "paul" wrote: vlookup will look up the eployee number and display as many columns as you want.Give us some exaples of how your data is laid out and what you want shown on your summary sheet -- paul remove nospam for email addy! "Stacey" wrote: 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? |
Reply |
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 |