Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi , hoping someone can help.
Using Excel 97 @work
I've got a spreadsheet with multiple sheets - days of the week Sun-Sat & a totals sheet ( 8 sheets in total)
3 columns ( A-C)each sheet headed Order No , colleague name and date.
I want to be able to display all the orders ( column A) raised for a given colleague ( Bot) across all the daily worksheets and them display the order numbers in the totals column , say column B and if possible only contain unique values as some orders if not cleared on the day raised will carry forward to the following days . If this is not possible I'll just run an advanced filter to remove duplicate.
( I've managed to do by vlookup , but only by displaying each if the days in seperate columns on the total sheet , I need all the orders to display as one list on the totals column
Hoping someone can help
Using Excel 97 @work
I've got a spreadsheet with multiple sheets - days of the week Sun-Sat & a totals sheet ( 8 sheets in total)
3 columns ( A-C)each sheet headed Order No , colleague name and date.
I want to be able to display all the orders ( column A) raised for a given colleague ( Bot) across all the daily worksheets and them display the order numbers in the totals column , say column B and if possible only contain unique values as some orders if not cleared on the day raised will carry forward to the following days . If this is not possible I'll just run an advanced filter to remove duplicate.
( I've managed to do by vlookup , but only by displaying each if the days in seperate columns on the total sheet , I need all the orders to display as one list on the totals column
Hoping someone can help