Hi all,
I am trying a macro that will find the word "Fort" in row 5 in the source workbook and copy its whole column to another workbook. Any help please... Thanks.
Hi all,
I am trying a macro that will find the word "Fort" in row 5 in the source workbook and copy its whole column to another workbook. Any help please... Thanks.
If it only occurs once:
Or if, as likely, you don't need the whole column:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by StephenR; 11-27-2009 at 09:02 AM.
Hi Stephen,
The first one worked as a start. The second didn't. How about if I only wanted to copy such range like from row 5 to row 12? Its just that I've got some figures underneath row 12 and above row 5 that I don't need to copy. Thanks.
Not sure why the second one didn't work. Try this:
Please Login or Register to view this content.
Thanks for that man! That's what I needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks