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.



"Eduardo" wrote:

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

"dmoney" wrote:

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" wrote:

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