| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro to select a tab
Hi everybody, I hope you can help me with this one. I have a Pivot table
where I have a macro that update my invoicing information from an external data. So every month I run that macro to have the sales of the previous month. The month in the PV is in cell B14. In the same worksheet I have different tabs for each month where I copy the information as values in order to create a Summary of sales. What I need to do is once the macro is run and the month show up in cell B14 is go to the corresponding tab i.e. Aug. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
| Macro to select files and then run different macro on selected file | Excel Programming | |||
| Select a macro button with a macro | Excel Programming | |||
| How to Select a Row in VB Macro | Excel Programming | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Threaded Mode
