Sales Data macro or function help

Shezan01

New Member
Joined
Mar 29, 2013
Messages
4
I have a workbook with sales from 2013 and last year sales from 2012. The workbook contains 52 sheets for each week in the year. I used the same workbook for 2014 but I am now trying to extract the 2013 sales and place them in the 2014's Last years sales.
So I can do it by using this function "='[2013.xlsx]Week 1'!C$15" and then drag it to every cell in that week, but to go to the next sheet copy the formula and change the Week 1 to Week 2 for 52 sheets seems like an issue to me. Any macros that may make it easier.

Thanks in advance
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

farmerscott

Well-known Member
Joined
Jan 26, 2013
Messages
813
Office Version
  1. 365
Platform
  1. Windows
Shezan,

No VBA expert but will ask a few questions to get things going.......

Can you give-
1. the name of the workbooks, are they in the same location.
2. name of the sheets within the workbooks (week1, week2,???)
3. what range the old data is in and where it needs to go in your 2014 sheets

thx

FarmerScott
 

Watch MrExcel Video

Forum statistics

Threads
1,129,814
Messages
5,638,493
Members
417,029
Latest member
lingx86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top