R
REDSHOTPICKS
is it possible to use a variable to call up information from anothe
page on a workbook. it is easy to refrence another page by entering
sheet1!a1 for example if I want to get th
data in sheet1 cell a1 but that needs to be hard coded is i
possible to enter sheet1 as text in one cell and have other cell
refrence that value to call up information from sheet1 I need to d
this because i have about 60 different functions on one page that refe
to various parts of other pages and i want to be able to enter sheet1
or sheet2 or sheet3 only once so I dont have to change all 60 cell
to get the different information i require help greatly appreciated
in cell a1 I want to be able to enter my variable sheet2 or an
other sheet name
I want to be able to change this text at will
and have the function in a2 =sheet1!a1 change als
page on a workbook. it is easy to refrence another page by entering
sheet1!a1 for example if I want to get th
data in sheet1 cell a1 but that needs to be hard coded is i
possible to enter sheet1 as text in one cell and have other cell
refrence that value to call up information from sheet1 I need to d
this because i have about 60 different functions on one page that refe
to various parts of other pages and i want to be able to enter sheet1
or sheet2 or sheet3 only once so I dont have to change all 60 cell
to get the different information i require help greatly appreciated
in cell a1 I want to be able to enter my variable sheet2 or an
other sheet name
I want to be able to change this text at will
and have the function in a2 =sheet1!a1 change als