Reference different worksheets

[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

 

[Bob Phillips]

=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)

 

[Stan Brown]

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

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?

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