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?
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 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | EH | |||||||
2 | ||||||||
3 | ||||||||
4 | Product | Average Weekday | Saturday | Sunday | Weekend | |||
5 | 00001 | 239,531 | 39,966 | 547,998 | 587,964 | |||
6 | 00002 | 18,301 | 5,615 | 8,465 | 14,080 | |||
7 | 00003 | |||||||
8 | 00004 | 8,243 | 5,549 | 0 | ||||
9 | 00005 | |||||||
10 | 00006 | |||||||
11 | 00007 | |||||||
12 | 00008 | 71,123 | 6,081 | 346,514 | 352,595 | |||
13 | 00009 | 0 | 0 | 0 | 0 | |||
14 | 00010 | |||||||
15 | 00011 | 5,176 | 3,499 | 2,479 | ||||
16 | 00012 | |||||||
17 | 00013 | |||||||
18 | 00014 | |||||||
19 | 00015 | 35,538 | 9,426 | 44,021 | 53,447 | |||
20 | 00016 | |||||||
21 | 00017 | 34,086 | 621 | 414 | 1,035 | |||
22 | 00018 | |||||||
23 | 00019 | |||||||
24 | 00020 | |||||||
25 | 00021 | |||||||
26 | 00022 | 11,001 | 1,162 | 0 | 1,162 | |||
27 | 00023 | |||||||
Summary |