How do I reference a worksheet name through a formula?
in [Functions]
|
From: pv6901 on 28 Jan 2010 09:39 I would like to reference a cell to obtain a worksheet name rather than have the worksheet name in the formula. So rather than have Sheet1! in the formula I would like to have a cell that contains the text "Sheet1"
From: Fred Smith on 28 Jan 2010 09:40 Check out the Indirect function. Regards, Fred "pv6901" <pv6901(a)discussions.microsoft.com> wrote in message news:DD37DFEF-3191-4856-8B8A-BD88FBA332A4(a)microsoft.com... >I would like to reference a cell to obtain a worksheet name rather than >have > the worksheet name in the formula. So rather than have Sheet1! in the > formula > I would like to have a cell that contains the text "Sheet1"
From: Dave Peterson on 28 Jan 2010 09:44 If A1 contains the text: Sheet1 and you wanted to retrieve the value from Z99 in Sheet1, you could use this formula: =indirect("'" & a1 & "'!z99") If you need to retrieve data from worksheet in a different workbook, be aware that that "sending" workbook has to be open for =indirect() to work the way you want. pv6901 wrote: > > I would like to reference a cell to obtain a worksheet name rather than have > the worksheet name in the formula. So rather than have Sheet1! in the formula > I would like to have a cell that contains the text "Sheet1" -- Dave Peterson
From: Mike H on 28 Jan 2010 10:04 Hi, There'sno guarantee it makes you formula simpler but lets say we have Sheet1! in Cell A1, this formula returns A1 of sheet 1 =INDIRECT(A1&"A1") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "pv6901" wrote: > I would like to reference a cell to obtain a worksheet name rather than have > the worksheet name in the formula. So rather than have Sheet1! in the formula > I would like to have a cell that contains the text "Sheet1"
|
Pages: 1 Prev: HOW TO USE BAHTTEXT FORMULA Next: help with Conditional formatting pairs of cells |