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?
|