LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
sa02000
 
Posts: n/a
Default Copy only new rows


I have two worksheets with partially same data. I need to copy only the
new rows from worksheet1 to worksheet2 (worksheet1 is updated
automatically every month). And if I can highlight the new rows copied
into the worksheet2 that will be even better.
Is there any easy way to do it or any in-built function in excel that
will do this?

Thanks, Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=526190

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Rows to another Sheet Automatically Tim & Holly Excel Worksheet Functions 2 March 7th 06 12:53 PM
How do I NOT copy hidden rows to a new worksheet? Steve Excel Discussion (Misc queries) 3 March 3rd 06 05:47 PM
Copy and paste only the rows with subtotals achidsey Excel Discussion (Misc queries) 3 August 29th 05 10:00 PM
How to have formulas and formats auto copy to new inserted rows DippyDawg Excel Discussion (Misc queries) 2 August 5th 05 03:09 PM
copy exact values from RangeA to Range B which has extra rows guptasa@gossami .com Excel Discussion (Misc queries) 1 May 16th 05 09:21 AM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"