Using weekly sales data effectivly

sbentham

New Member
Joined
Apr 5, 2018
Messages
1
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.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

frank_AL

Active Member
Joined
Oct 30, 2015
Messages
439
I recommend you read up on using Pivot Tables. They are a very powerful tool for data analysis just as you are suggesting you need.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,645
Messages
5,549,156
Members
410,902
Latest member
G Slim
Top