Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I need to develop a macro which has to first identify and then calculate between two sheets. I just started to learn to program macros so please help me with this one (as it seems far to complex to do that on my own). Details: The macro starts in sheet1 in row 3 takes the values in this row of column A, C, D and compares them with sheet2 with the same columns but any row. If the values match the macro should go on and subtract the values in Column M in sheet2 from sheet1 and output the result in Column N in row 3 in sheet1. If the macro does not find a match of row 3 of sheet1 in sheet2 it should go on to the next row in sheet1 and start with the comparison of column A, ... and so on. Many thanks for any support!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Sheets values in two colums | Excel Worksheet Functions | |||
compare contents between sheets and identify matching values | Excel Programming | |||
Compare values in multiple sheets | Excel Programming | |||
How do I compare two values to calculate a total? | Excel Worksheet Functions | |||
HOW DO I COMPARE TWO SHEETS AND IDENTIFY WHICH CELLS DIFFER | Excel Discussion (Misc queries) |