Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 20 sheets (like templates) and ALL of them have different information
ONLY for rows 2, 3, 4 and 5. The remaining cells of these sheets have information (formulas and/or values) that will match each other. The main-sheet, the one with the right Formulas and Values, will be the current sheet that I will start running this macro. I am looking for something like a spellchecker, but in this case will be like a €śFormulas and Values checker between similar Sheets€ť. For example: if I am in sheet3 and run this macro, it will compare formulas and values in each CELLS, (but not on rows 2, 3, 4 and 5), between sheet3 and the rest of sheets. Moreover, It will prompt me for the first occurrence that this macro find different between sheet3 and sheet€ťn€ť cells. This prompt will let me decide to update the cell in sheet3, sheet€ťn€ť, to Ignore the prompt or cancel the macro. Any idea how to implement this macro? Thanks Coco. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Sheets values in two colums | Excel Worksheet Functions | |||
create alert when in sheets are grouped | Excel Worksheet Functions | |||
dummy alert - divide values by values | Excel Discussion (Misc queries) | |||
compare two cell values on different sheets | Excel Programming |