I really don't know where to start here so I'm hoping one of you clever folk out there will know the answer!!
I've got a spreadsheet (ironically enough!) with a list of part numbers in Column A.. Column B & C are headed Sales 7 & Sales 28.
There is another tab in the workbook which is total sales to date - what I'd like to do is referencing Column A products against how many were sold in a 7 and 28 day period from the current days date.
Currently I'm having to pull three reports (Weekly/Monthly/To Date) sales and then use a lookup to work out how many off each tab. It's time consuming and the data is already there in the To Date tab, I just don't know how to go about getting it out!!
Thanks so much in advance!!
I've got a spreadsheet (ironically enough!) with a list of part numbers in Column A.. Column B & C are headed Sales 7 & Sales 28.
There is another tab in the workbook which is total sales to date - what I'd like to do is referencing Column A products against how many were sold in a 7 and 28 day period from the current days date.
Currently I'm having to pull three reports (Weekly/Monthly/To Date) sales and then use a lookup to work out how many off each tab. It's time consuming and the data is already there in the To Date tab, I just don't know how to go about getting it out!!
Thanks so much in advance!!