Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
inventory | New Users to Excel | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
inventory | Excel Discussion (Misc queries) | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) |