VBA macro to select a tab

[Eduardo]

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

 

[dmoney]

you can assign the value of cell B14 to a variable and use the variable to
select the appropriate tab.

dim tab as string
tab=range("b14").value
worksheets(tab).select


HTH

dmoney

 

[Eduardo]

Hi, dmoney, and thank you for the replay. I am getting a compile error. I am
using excel 2007

 

[Eduardo]

Hi Dmoney I figure out, just modify your code Thank you very much

Dim workbooktab As String
workbooktab = Range("b14").Value
Worksheets(workbooktab).Select

 

[Barb Reinhardt]

I bet when you got the compile error, you were running the code from another
worksheet besides the one with the value in B14.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.