LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Comparing then Replacing

Hi Everyone,

I have an excel file, with 2 sheets. I need to take the original, and
row by row compare cols a through n, if those all match exactly, then
copy what is in col o from the original to the new sheet col o, on the
line that matches.

There are lines inserted in the new sheet that are not in the original,
and need to stay untouched, therefore the order of the two sheets is
not the same.

These files are 2400+ rows long.

If anyone could lend a hand, that would be great!

Thanks!

Jeff Basham


 
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
replacing 0's L.S. Excel Discussion (Misc queries) 4 April 2nd 08 03:42 PM
Replacing ? ddate Excel Worksheet Functions 1 January 25th 07 01:31 AM
replacing help fluci Excel Programming 0 August 4th 05 08:12 PM
Replacing #N/A with a '0' (zero) neilcarden Excel Worksheet Functions 5 April 20th 05 02:49 PM
replacing #N/A with 0 Mark Excel Discussion (Misc queries) 3 April 7th 05 10:02 PM


All times are GMT +1. The time now is 07:27 PM.

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"