Dynamic formulas including worksheet references

Hi,

I have the following "minor" headache:

I have on one summary worksheet different company names in rows with their corresponding key figures (formulas) in the columns. Every company has a corresponding worksheet, that is named after the company (done automatically with a macro.) My question would be if it is possible to have the following formula/reference in the individual colums:

company A =Worksheet of company A $A$1

company B = Worksheet of company B $A$!


that I could basically copy down every column and which would take the worksheet reference from the column with the company names.

Cheers

Lars

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" <lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com> wrote
in message news:lars22222.1ss2qs_1122383207.1004@excelforum-nospam.com...
>
> Hi,
>
> I have the following "minor" headache:
>
> I have on one summary worksheet different company names in rows with
> their corresponding key figures (formulas) in the columns. Every
> company has a corresponding worksheet, that is named after the company
> (done automatically with a macro.) My question would be if it is
> possible to have the following formula/reference in the individual
> colums:
>
> company A =Worksheet of company A $A$1
>
> company B = Worksheet of company B $A$!
>
>
> that I could basically copy down every column and which would take the
> worksheet reference from the column with the company names.
>
> Cheers
>
> Lars
>
>
> --
> lars22222
> ------------------------------------------------------------------------
> lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
> View this thread: http://www.excelforum.com/showthread...hreadid=390167
>