| 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 |
| 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 | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
