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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Copy rows to another sheet 6
My Never ending ARRAY code problems 18
Eliminate blanks while copy row and transpose 11
Breaking One Row into Multiple Rows using VBA Macro? 2
Copy rows with today's date to new sheet 1
Code copies twice...? 13
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1

Back
Top