Excel Macro's use on several tabs?
 

I have a spreadsheet with roughly 90 provider tabs, each built off of the
same template. The data in each tab is in the same place, but the data is
specific to each provider. Each quarter I prepare a report for each of the
providers, manually graphing some of the data on each tab. i have tried to
create a Macro that would allow me to click on each tab and hit the short cut
and then have the graph appear on that tab. Problem is that the macro only
works on one tab; the one it was created in. When I look at the VB it
references that tab in the program. is there anyway to get it to reference
the currently open tab?

Excel Macro's use on several tabs?
 

Hi,
post the code but I reckon you want to change somethin like

Sheets(1)...(or possibly Me.)
to
Activesheet..

Hth,
O