| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a cell reference to select a worksheet within a macro
I hope this makes sense!!
I have a spreadsheet for data collection. This has 4 teams (1,2,3 and 4) which currently gets merged onto 1 huge spreadsheet. I want to be able to run a macro which splits the data onto 4 separate sheets. Team 1 Team 2 Team 3 Team 4 I have tried using Sheets(AC8).Select - did not work. AC8 being the cell referred to from the drop down box where the team number is selected. Any ideas? Regards Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell as worksheet reference (macro) | Excel Discussion (Misc queries) | |||
| Reference another Worksheet and Conditionally Select Data | Excel Worksheet Functions | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| select worksheet to run macro | Excel Discussion (Misc queries) | |||
| Help Please! Macro Error on Select Worksheet | Excel Programming | |||
Threaded Mode
