Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know this has probably been discussed milliions of times before, but
I am still quite confused. I need to compare two sheets for differences, without highlighting them or anything. just comparing. Basically, I have a sheet that updates from an internet service that's always running, and I needed a small macro that will check if the service has frozen. The way I see it, the best thing is to have a macro that compares the updating sheet to a hidden sheet that will be a copy of it, so the macro structure would be something like ontime run every 2 minutes compare sheet1 and hiddensheet if sheet1 = hiddensheet then msgbox "verify internet connection" else copy sheet1 nad paste on hiddensheet I hope I have made myself clear, and that somebody out there can help me, please... Thank you for any help you may be able to give Lorenzo Lucchini Gilera |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
Comparing 2 sheets | Excel Discussion (Misc queries) | |||
Sheets comparing | Excel Worksheet Functions | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Worksheet Functions |