copy rows to new sheet

  • Thread starter Thread starter Beginner at Heart
  • Start date Start date
B

Beginner at Heart

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.
 
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.
 
Back
Top