Im after a macro that will delete all but certain selected columns.
ie, I want to keep colum B, C and D and delete the rest. This may change and the Column name may be in different locations.
Thanks
ie, I want to keep colum B, C and D and delete the rest. This may change and the Column name may be in different locations.
| Crystal(5) (2).xls | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | A | B | C | D | E | F | G | ||
| 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
Sheet2 | |||||||||
Thanks
