Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump to a sheet based on the reference in a cell.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump to a sheet based on the reference in a cell.
Yo can't stop a macro in the middle to check a worksheet. what yo can do is
either highlight the items ot check with a macro (color the cell or rows), or add a hyperlink on the check items to make it easier for the user to go to the check items. "Elton Law" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on the selction from a drop down box, jump to a cell | Excel Discussion (Misc queries) | |||
Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
Could I jump to another Sheet by clicking on a cell | Excel Programming | |||
Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
Copy rows to new sheet based on variable cell reference | Excel Programming |