Combing Multiple Workbooks - Twist

LearningVBA

New Member
Joined
Sep 16, 2006
Messages
14
Each month I recieve approximatly 150 - 180 workbooks (varies month to month) all of which I have to enter into a Summary Workbook.

The workbooks are identical in layout and the data is held in cells C5:H27, the identifier for each site is shown in cell A1 with the description in cells A5:A27

The Summary workbook has 16 worksheets, with four named Weekday, Saturday, Sunday and Weekend

In the example below you can see that each of the columns has the same four identifiers. I need to be able to copy the data from each of these columns onto the correct worksheet along with the identifier.

Could someone please assist?
Edinburgh.xls
ABCDEF
1EH
2
3
4ProductAverage WeekdaySaturdaySundayWeekend
500001239,53139,966547,998587,964
60000218,3015,6158,46514,080
700003
8000048,2435,5490
900005
1000006
1100007
120000871,1236,081346,514352,595
13000090000
1400010
15000115,1763,4992,479
1600012
1700013
1800014
190001535,5389,42644,02153,447
2000016
210001734,0866214141,035
2200018
2300019
2400020
2500021
260002211,0011,16201,162
2700023
Summary
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

LearningVBA

New Member
Joined
Sep 16, 2006
Messages
14
This is the result that I'm after:-
Book2.xls
ABCDEFGH
1
2
3
4Product / IdentifierEHBLCVML
500001239,53199,24473,70590,0060
60000218,30111,73306,4820
700003
8000048,2431,5010
900005
1000006
1100007
120000871,1230000
1300009022,3366589,7570
1400010
15000115,1765260
1600012
1700013
1800014
190001535,53813,2529798,2520
2000016
210001734,0861563010
2200018
2300019
2400020
2500021
260002211,0011,5861,9550
2700023
280
Weekday
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,117
Messages
5,857,482
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

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