See the attached.

Attached Files

SampleData_7.xlsx (54.4 KB, 12 views)

Hi Xor this is exactly what I was after and thanks for educating me re name manager. As this works what is the best way for me to get the live data in - should I save as and add in the real data in the data sheet? I obviously do not want to mess with the formulas. One additional question is there an easy way to incrementally add the days to the merged data in cells 09-EE9 so that Monday follows Tuesday etc without having to manually copy and paste? thanks for all your help thus far - really appreciated

You wrote:
As this works what is the best way for me to get the live data in - should I save as and add in the real data in the data sheet?

I see no reason to save as add in.

See my comments in sheet Data.

Attached Files

SampleData_8.xlsx (55.1 KB, 11 views)

Thank you Xor I will start adding in the live data and let you know when all complete - excellent work regardless have a great weekend

Happy new year Xor and I just wanted to let you know that I have added in all data to the data sheet and the weekly summation works fine. Can you let me know if, going forwards, I am able to delete or add rows to the data sheet or will this interfere with the rearrange sheet you created?
Thank you

Which rows do you want to delete?

Hi further to the advice of Xor last year I have rearranged my data vertically however still have a problem with summing the total sales weekly and I would really appreciate some help.
Please see the attached updated spreadsheet.

On sheet 1, you will find all the core data that will be input.
In columns N and 0 you will see the summation of the shop sales and orders by day.
The start of the week is on Monday so the first Monday of the financial year will be 10th April 2017.
All I want to do is take the vertical daily sales and orders in sheet 1 and sum them horizontally in sheet 2 - but I cannot do this by copying down so have to do it manually.
Is there a formula that can do this easily starting from 10th April and summing every week for the entire year?

Thanks in advance

Attached Files

Data Query 21st March 2017.xlsx (34.3 KB, 9 views)