Add a Col. to a Macro

[manuscriptguru]

Hello,
The macro below copies col. C and O from the original sheet and create a new workbook with these two columns.. I would like to add col. P into the new workbook. Can someone edit this macro to make it copy col. P as well?

Thank you.

Please Login or Register  to view this content.

[PCI]

See next code
Adjust Const for your next modification

Please Login or Register  to view this content.

[manuscriptguru]

Thank you. The problem is that your macro copies the formulas in col O & P, while what I need is actually the result of the formula.

I hope this makes sense.

Please see the attached Excel.

[scottiex]

First done your way

Please Login or Register  to view this content.

although I think more efficient and easier to understand is more like this

Please Login or Register  to view this content.

[scottiex]

sorry forgot the sort.
I imagine you dont have any problem with that but these 2 lines

Please Login or Register  to view this content.

[jindon]

If you are using array for your learning purpose then seethe code.

Please Login or Register  to view this content.

[PCI]

Thank you. The problem is that your macro copies the formulas in col O & P, while what I need is actually the result of the formula.

So see next code

Please Login or Register  to view this content.

[manuscriptguru]

Thank you all for your help! This is an amazing forum. The macro works!

[PCI]

You're welcome and thx for the rep

[jindon]

Glad you like it and thanksbfor the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.