View Single Post
 
Old 02-13-2014, 10:45 AM
konopca konopca is offline Windows XP Office 2003
Novice
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default Find specific rows then copy and paste to new doc

Hi everyone.
I have a table with two hundred plus rows. I would like to be able to find the rows that have the word "Draft" in the 3rd column. I then want to copy the entire row, loop through the rest of the table while finding and copying, and then paste into a new document.

I think it will have to be macro code and this is beyond my abilities.

The table is eight columns if that matters. The word Draft is not the only word in column 3. Oh and column 3 is a hyperlink but does not have to be pasted as a hyperlink.

Carol
Reply With Quote