thank you for some direction, i'm very rusty when it comes to vba.
rod.

"JLGWhiz" wrote:

Try this site:

http://www.rondebruin.nl/copy1.htm

"rodchar" wrote:

hey all,

Each worksheet
Find KeyWord in first column
Starting with row after keyword
Take certain columns and copy to next blank row in Sheet1
Next

Can someone please show me some psuedocode on how to accomplish this?
Mainly, how do you copy a row from one sheet and paste it into another sheet
on the next available blank line?
How do you tell vba to look in the first column for a keyword?

thanks,
rodchar