Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I think I'm missing a vital point here. I often use existing (not defined)
labels to reference cells or calculate values on a sheet. Can I also do this from a different sheet without defining ranges by somehow adding the sheet name in the reference? (Tried a few permutations of this idea but always get a #name? error.) TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Putting Sheet Names in a range and renaming it? | Excel Worksheet Functions | |||
Function to List an Excel Workbook's Sheet Names | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
sheet names | Excel Discussion (Misc queries) | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions |