Help - A question from Ella.

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

Try something like:

Code:

---

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

---

I tried and it is working.
Thanks so much

Ella

You're Welcome :beerchug:

Take Care