Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I receive a spreadsheet from someone outside of my company's network. I take
this spreadsheet and add columns to either side for my company's data. Example: Original spreadsheet ("OS") A B C 1 pear 1354 04-Sep-07 2 lime 2000 01-Jan-08 My spreadsheet ("MS") A B C D E 1 data pear 1354 04-Sep-07 data 2 data lime 2000 01-Jan-08 data When the other person adds or changes their information, they send me a copy of their updated spreadsheet. What I would like to do is use a macro to compare the array A1:C2 ("OS") to the array B1:D2 ("MS") to find the updates. Can anyone help me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare arrays | Excel Worksheet Functions | |||
Compare arrays | Excel Worksheet Functions | |||
HOW TO COMPARE COLUMN VALUES IN EXCEL? | Excel Worksheet Functions | |||
Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |