Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-21-2017, 03:33 AM
jdsg0 jdsg0 is offline Transferring data from one sheet to another Windows 10 Transferring data from one sheet to another Office 2003
Novice
Transferring data from one sheet to another
 
Join Date: Dec 2016
Posts: 14
jdsg0 is on a distinguished road
Default Transferring data from one sheet to another

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
Attached Files
File Type: xlsx Data Query 21st March 2017.xlsx (34.3 KB, 13 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Transferring data from one sheet to another How to transferring Word data to an Excel sheet statue.919 Word VBA 16 06-18-2020 05:14 PM
Transferring data from one sheet to another transferring data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft