Hi,
I am relatively new to the intricacies offered by excel despite years of using basic formulas.
I am an account manager, and each week we receive sales information form our customer. We have approx 30-40 SKUs listed, but this can change depending on the week and season. Some weeks the list can change slightly in article numbers and order in which they appear on the spreadsheet.
I currently save each of these sheets int eh same workbook, using the date as the title of the sheet.
What i want to do i find a way of collating and using the sales information. The spreadsheets contain around 30 columns, but i only want 4-5 pieces of information.
On e a new black sheet at the start of the workbook, i would like to take one of every number SKU used across all of the sheets, and then track across the columns so that the total sales for each week are automatically calculated.
Help is super appreciated in advance! And sorry if I have not been very clear, I am not sure how i can upload an image to show with more clarity.
I am relatively new to the intricacies offered by excel despite years of using basic formulas.
I am an account manager, and each week we receive sales information form our customer. We have approx 30-40 SKUs listed, but this can change depending on the week and season. Some weeks the list can change slightly in article numbers and order in which they appear on the spreadsheet.
I currently save each of these sheets int eh same workbook, using the date as the title of the sheet.
What i want to do i find a way of collating and using the sales information. The spreadsheets contain around 30 columns, but i only want 4-5 pieces of information.
On e a new black sheet at the start of the workbook, i would like to take one of every number SKU used across all of the sheets, and then track across the columns so that the total sales for each week are automatically calculated.
Help is super appreciated in advance! And sorry if I have not been very clear, I am not sure how i can upload an image to show with more clarity.