PDA

View Full Version : Solved: Help - A question from Ella.



brettdj
04-21-2005, 06:14 PM
Help
I am new to excel macro but I would like to have some codes that will automaticaly select a series of columns from one workbook to another and save it.
the initial columns are: A, B,C, D, E, G, H, I, J, K, L, M, N, O,P and so on. I would like to be able to copy for instance B, D,G, I, K, M, P and so on --to another workbook.

I will really appreciate your help

Thanks

Ella

Jacob Hilderbrand
04-21-2005, 06:18 PM
Try something like:

Workbooks("Workbook With Data Name").Sheets("Sheet1").Range("B:B").Copy _
Destination:=Workbooks("New Workbook Name").Sheets("Sheet1").Range("B:B")

Ella
04-23-2005, 06:43 AM
I tried and it is working.
Thanks so much

Ella

Jacob Hilderbrand
04-23-2005, 08:52 AM
You're Welcome :beerchug:

Take Care