LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default compare sheets (values and formulas), alert it like spellcheckers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Sheets values in two colums Geir[_2_] Excel Worksheet Functions 1 April 7th 08 01:55 PM
create alert when in sheets are grouped Twishlist Excel Worksheet Functions 1 April 5th 07 04:50 AM
dummy alert - divide values by values Micayla Bergen Excel Discussion (Misc queries) 1 May 4th 05 02:16 AM
compare two cell values on different sheets sagarh Excel Programming 3 February 16th 04 01:42 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"