Making formula read sheetname from a cell in my main sheet.

[jon]

Hi,
How do I ask this question ?

Here's an attempt.

I have a sheet called ADMIN that contains numerous buttons that run VB
functions I have created.

The sheet ADMIN has a cell (V4) that contains the name of the current
worksheet that is being processed.

I have another sheet called OUTPUT, and the OUTPUT cell C3 currently has the
formula =ROUND(Newsagents!F9*$C$1,2).

I want to know how to put the word Newsagents in cell ADMIN!V4 and then
change the formula on the line above to read from admin V4.

I know how to do it in VB, but on this occasion I need to do it in the
cell's formula.

Can anyone help ?

Thanks

Jon

 

[Pete_UK]

Try this:

=ROUND(INDIRECT(ADMIN!V4&"!F9")*$C$1,2)

Hope this helps.

Pete

 

[jon]

It works,
Thanks, you've saved me hours.

Cheers

Jon


Try this:

=ROUND(INDIRECT(ADMIN!V4&"!F9")*$C$1,2)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Jon - thanks for feeding back.

Pete