pingwin77
03-26-2009, 08:07 AM
I have the following workbook and need a macro for it.
1. copy all the data from sheet 2, column B
2. Search for the next open Column on sheet 3 by looking across row 2
3. Paste special / Values only in the open column starting on row 2. I need to keep the dta in row 1 to label my information.
I know how to do the first part or even record the macro to do the copy and paste special / values. I do not know hoe to search across a row for the next open column. Can someone explain this or just write a quick macro that I can attach to a button?
Oh. I will have the button on sheet 3 so I can execute the macro from there.
Thanks a ton!
1. copy all the data from sheet 2, column B
2. Search for the next open Column on sheet 3 by looking across row 2
3. Paste special / Values only in the open column starting on row 2. I need to keep the dta in row 1 to label my information.
I know how to do the first part or even record the macro to do the copy and paste special / values. I do not know hoe to search across a row for the next open column. Can someone explain this or just write a quick macro that I can attach to a button?
Oh. I will have the button on sheet 3 so I can execute the macro from there.
Thanks a ton!