Inventory questions
 

I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?

Inventory questions
 

=A1&"!$A$1"

Is that what you're looking for?
--
-SA


"Susan" wrote:

I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?

Inventory questions
 

yes, but one more quick question. i am trying to get a link to another
workbook

is there a way to add the other workbook in front of that. i have tried

='[list.xls]&a1&"!$a$1" but that did not work, any help???

"StumpedAgain" wrote:

=A1&"!$A$1"

Is that what you're looking for?
--
-SA


"Susan" wrote:

I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?

Inventory questions
 

"Susan" wrote:

yes, but one more quick question. i am trying to get a link to another
workbook

is there a way to add the other workbook in front of that. i have tried

='[list.xls]&a1&"!$a$1" but that did not work, any help???

"StumpedAgain" wrote:

=A1&"!$A$1"

Is that what you're looking for?
--
-SA


"Susan" wrote:

I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?

Inventory questions
 

You'll havd to do something like the following:

=[list.xls]Sheet1!$A$1&"!$a$1"

you'll havd to substitute whatever your worksheet name is for "Sheet1".
Hope it helps!
--
-SA


"Susan" wrote:

yes, but one more quick question. i am trying to get a link to another
workbook

is there a way to add the other workbook in front of that. i have tried

='[list.xls]&a1&"!$a$1" but that did not work, any help???

"StumpedAgain" wrote:

=A1&"!$A$1"

Is that what you're looking for?
--
-SA


"Susan" wrote:

I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?

Inventory questions
 

=INDIRECT(A1&"!A1")

The first A1 refers to the cell with the sheet name (in your case 'sheet1'),
the second A1 pulls out the value from cell A1 in the referenced sheet.

Joerg Mochikun


"Susan" wrote in message
...
I'm working in Excel for Inventory. I made several worksheet in a file.
I want to make a summary page for each worksheet.
I want: when I put the worksheet name in A1 cell, B1 cell refer this name
as
worksheet name like:
A1: sheet1
B1: sheet1!$A$1
when I change A1 to sheet2, B1 should chang to: sheet2!$A$1

Anyone knows how to do it?