PDA

View Full Version : Copy columns based on cell value



inajica
08-29-2008, 10:25 AM
I am trying to create a macro that will copy entire column based on a cell value.

For example, In workbook "1", cell "a1", I have a value "A" . That will copy the entire A column in workbook 2, and paste it into workbook 3 cell a1.

Thank you for any help with this

mdmackillop
08-29-2008, 10:55 AM
I'm guessing you have more than one column to copy. Are you looking to check cells in a range? How do you determine what should be copied and to where it should be pasted?