| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare to columns on two different spread sheet, only pick up the
I have created the macro to check the changes compare to the values in sheet1
vs sheet2, if anything changed more than certain amount, it will be copied and pasted to another sheet. The thing is I couldn't figure out how to find out the names only on sheet1 or only on sheet2. for example, if i check column A on each sheet, how can i find out the names only on sheet1 and only on sheet2, then i can copy, paste the value to another spread sheet? Thanks a lot. Ming |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare the words in columns of the excel sheet | Excel Discussion (Misc queries) | |||
| How do I print certain (specifics) columns in Excel spread sheet? | Excel Worksheet Functions | |||
| unhide columns a-c on spread sheet | Setting up and Configuration of Excel | |||
| Setting borders for two rows and all columns on spread sheet | Excel Worksheet Functions | |||
| Can I add more columns to a spread sheet or is limit 256 columns | Excel Discussion (Misc queries) | |||
![Ming[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
