I am attempting to import data from another worksheet based on selectable
For example, if I have 3 worksheets A, B, & C with a range name of RangeB
for the sheet B data and RangeC for the sheet C data. On Sheet A, a
specific cell say A1 will contain either A or B which would identify the
range name. I want to reference cell A1 as part of the formula to bring in
data from the other sheets.
The formula would be something like if Cell A1=Range A :
='A1'!$B$1 where A1 should reference RangeA and bring in the contents of
Any help would be greatly appreciated.