| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to compare values in a workbook
I have a workbook with 52 worksheets. The first 2 hold base data fro the
rest. I need a macro that will compare one cell to a range of data from the first 2 worksheets. For example:on worksheet one I have a range a1:a500,consider this the base data. On another worksheet i have one cell of data that needs to be compared to the range mentioned above. If the data in the cell does not match the range, it should change the data in the cell red. As you can tell I am new at this, any help would be appreciated Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy values to Workbook | Excel Discussion (Misc queries) | |||
| Excel VBA Macro to compare 2 worksheets for same values | Excel Worksheet Functions | |||
| Passing selected workbook name and values to a macro | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| Macro to compare values and return exact matching value | Excel Programming | |||
Threaded Mode
