copy rows to new sheet
 

I have a tracking file on our server (trackinglog.xls), so I cant edit it.
What I need to do is check column H for a certain lastname, first name,copy
each row that has that name to another file (trackinglog-mine.xlsx) starting
at row 6.

copy rows to new sheet
 

Open your file, turn on macro recorder. Then manually open the remote file,
search for your name, copy row to your file. Close remote file. Turn off
recorder. This will give you an outline code to modify and use to automate
the process.

--

Regards,
Nigel




"Beginner at Heart" wrote in
message ...
I have a tracking file on our server (trackinglog.xls), so I cant edit it.
What I need to do is check column H for a certain lastname, first
name,copy
each row that has that name to another file (trackinglog-mine.xlsx)
starting
at row 6.

copy rows to new sheet
 

See also
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Beginner at Heart" wrote in message
...
I have a tracking file on our server (trackinglog.xls), so I cant edit it.
What I need to do is check column H for a certain lastname, first name,copy
each row that has that name to another file (trackinglog-mine.xlsx) starting
at row 6.