![]() |
#1
|
|||
|
|||
![]()
Hi I would like to summarise my daily sales but cannot get the vertical data on sheet 1, to be displayed horizontally on sheet 2.
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 2017 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
statue.919 | Word VBA | 16 | 06-18-2020 05:14 PM |
![]() |
tofimoon4 | Excel | 3 | 10-03-2016 11:57 PM |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
transferring data from ACT to Outlook?! | Rudi | Outlook | 0 | 12-05-2012 12:56 PM |
Transferring data From One Office Suite To Another | Crlymop | Office | 0 | 02-24-2009 02:53 PM |