| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Compare Macro...
Sheet 1 contains 10,000 customers all uniquely identified by a customer
number in column A, with extra details stretching to column Z. Sheet 2 contains up to 10,000 customer details that are identical to sheet 1 in terms of customer number, but their additional details might have been changed. I need a macro that will compare sheet 1 and sheet 2 by customer number. If any row on sheet 2 is different to sheet 1 then the changed data sheet 2 will be transferred into sheet 1. Make sense? This has been driving me nuts...any help appreciated... Gordon. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Two Sheet | Excel Discussion (Misc queries) | |||
| Compare two data in same sheet | Excel Worksheet Functions | |||
| Compare data in one sheet to another | Excel Worksheet Functions | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
| Compare Sheet Cell to Sheet Column | Excel Worksheet Functions | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
