| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| DD | DE | DF | DG | DH | DI | |||
| 2 | EACH | EACH | TOTAL | |||||
| 3 | Glass Size 1 | Nominal Glss Size | SafeT x Code | SF by Line | Actual Glss Size | STC | ||
| 4 | 8 | 24 x 20 | NO | 27 | 22.5 x 18.5 | 24 x 20 STC 31 | ||
| 5 | 36 | 25 x 21 | NO | 131 | 23.5 x 19.5 | 25 x 21 STC 32 | ||
| 6 | 90 | 26 x 22 | NO | 358 | 24.5 x 20.5 | 26 x 22 STC 33 | ||
| 7 | 176 | 27 x 23 | NO | 759 | 25.5 x 21.5 | 27 x 23 STC 34 | ||
| 8 | 300 | 28 x 24 | NO | 1400 | 26.5 x 22.5 | 28 x 24 STC 35 | ||
| 9 | 468 | 29 x 25 | NO | 2356 | 27.5 x 23.5 | 29 x 25 STC 36 | ||
| 10 | 686 | 30 x 26 | NO | 3716 | 28.5 x 24.5 | 30 x 26 STC 37 | ||
| 11 | 960 | 31 x 27 | NO | 5580 | 29.5 x 25.5 | 31 x 27 STC 38 | ||
| 12 | 1296 | 32 x 28 | NO | 8064 | 30.5 x 26.5 | 32 x 28 STC 39 | ||
Storefront | ||||||||
I hope that comes out as it looks in explorer, I'm using chrome.
This table begins in GA2, and is repeated 10 times in the spreadsheet.
I would like to copy the data which is currently Column DI, DG, and DF in that order to a column a the end of the spread sheet; and repeat that copy and paste for similar columns in identical tables which I have not included for the sake of brevity.
I suspect I will have to reorder the columns so that I manage to get a contiguous range in each data set.
I have seen code which copies and pastes data from dynamic ranges consisting of one column and stacking them.
I suspect that I will be able to change the range name to identify the three columns in each table and the code should work. I will be using dynamic named ranges so that the code does not get cumbersome.
I just want to know if I'm on the right track?
