colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
I have a document with worksheets named WK01 to WK52.
Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change.
In column E of the week worksheets there will be a name of a product, column F the colour, cash sales would be in column H.
Using a sheet called summary, not yet set designed, I want to is firstly use the information from column E and F of each worksheet to create a list of the products without any duplicates, which is where the colour comes in, and for the sheet to also auto populate any new names that may be created in future weeks.
How would I do this?
Secondly I will then like this data to fall in to a league table with top sellers at the top based on column H, cash sales.
If you are able to give an example function/formula that would be great. Hopefully this all makes sense.
Any help would be amazing
Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change.
In column E of the week worksheets there will be a name of a product, column F the colour, cash sales would be in column H.
Using a sheet called summary, not yet set designed, I want to is firstly use the information from column E and F of each worksheet to create a list of the products without any duplicates, which is where the colour comes in, and for the sheet to also auto populate any new names that may be created in future weeks.
How would I do this?
Secondly I will then like this data to fall in to a league table with top sellers at the top based on column H, cash sales.
If you are able to give an example function/formula that would be great. Hopefully this all makes sense.
Any help would be amazing
