copy rows to new sheet

's Computer Specifications

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.

's Computer Specifications

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
(E-Mail Removed)

"Beginner at Heart" <(E-Mail Removed)> wrote in
message news:78A008DF-2183-4BC2-962A-(E-Mail Removed)...
>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.

's Computer Specifications

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

--

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

"Beginner at Heart" <(E-Mail Removed)> wrote in message
news:78A008DF-2183-4BC2-962A-(E-Mail Removed)...
>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy rows from one Data sheet to another sheet based on cell conte	John McKeon	Microsoft Excel Misc	2	15th May 2010 06:49 AM
copy rows to other sheet	Carpe Diem	Microsoft Excel Worksheet Functions	3	17th Dec 2007 06:58 PM
Copy rows onto existing sheet / start a new sheet if full	mg_sv_r	Microsoft Excel Programming	0	29th Nov 2007 12:57 PM
Search for rows in one sheet and copy into another sheet based on customer id	chitiksha@gmail.com	Microsoft Excel Worksheet Functions	1	22nd Oct 2007 03:09 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Microsoft Excel Programming	4	5th Oct 2007 04:00 PM