Reference different worksheets

  • Thread starter Thread starter WLMPilot
  • Start date Start date
W

WLMPilot

I have a workbook with sheets named 2005, 2006, 2007. Each sheet contains
data that matches the paychecks that my wife and I get. Each column is a
paycheck. I have another worksheet called STATS. On this sheet, I have a
form for each year (worksheet) that pulls totals from each sheet in order to
track total taxes against total income, and more. A tipical formula on the
STATS sheet used to pull this data is obviously ='2007'AB15 (which might be
YTD Income for one paycheck.

My question is this. How can I just have one form on the STATS sheet and
click on a command button, or something, in order to change the worksheet
reference from one year to another?

Thanks for your help,
Les
 
=INDIRECT(M1&"!AB15")

where M1 has the year number.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thu, 27 Dec 2007 07:21:01 -0800 from WLMPilot
I have a workbook with sheets named 2005, 2006, 2007. Each sheet contains
data that matches the paychecks that my wife and I get. Each column is a
paycheck. I have another worksheet called STATS. On this sheet, I have a
form for each year (worksheet) that pulls totals from each sheet in order to
track total taxes against total income, and more. A tipical formula on the
STATS sheet used to pull this data is obviously ='2007'AB15 (which might be
Click to expand...

I don't think so. I think it's ='2007'!AB15 .
YTD Income for one paycheck.

My question is this. How can I just have one form on the STATS sheet and
click on a command button, or something, in order to change the worksheet
reference from one year to another?
Click to expand...

If you don't want to write a macro, use INDIRECT("'" & A1 & "'!AB15")
where A1 (on the current worksheet) contains the year number.
 
Back
Top