Dear Expert,
Got a very complicated VB that I cannot figure out ?
A workbook contains few sheets.
"Raw", "Daily", "Weekly", "Monthly" ...

Can I set a marco if there is a text "Check" then go to the respective
sheets to update the data please ?
For LC115534, there is a "check" and "daily" ...
For GB120268, there is a "check" and "monthly" ... can it go to Sheets
"Monthly" and update something please ? I can use find "GB120268" and update
the latest data later.


Expiry In Sheets
LC115534 17-Feb-09 Daily Check 12.1
TR115776 17-Feb-09 Daily 11.2
GB116981 18-Feb-09 Daily Check 62.9
EQ117150 #N/A Daily 21.1
SS118845 18-Feb-09 Daily 117.4
AQ119605 18-Feb-09 Daily 24
TR120182 19-Feb-09 Daily 27
GB120268 17-Feb-09 Monthly Check 99
TR120513 19-Feb-09 Daily 24
GB120941 38
GB123547 19-Feb-09 Daily 24
GB125186 27-Feb-09 Weekly Check 37
EQ129944 #N/A Daily 84
SS130341 27-Feb-09 Monthly 67