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?

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?

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?