Excel: Cell contents to be used as worksheet reference


Using VBA I'm trying to read a cell (with a dropdown list of symbols) -- like "QQQ," and then use this symbol to refer to a worksheet in a formula such as: Range("N38").Formula = "=Offset(QQQ!AL10, 4, 2, 1, 1)" so that I can use whatever symbol is in the dropdown and have it refer to to a different worksheet. Thus if QQQ is in the dropdown cell I'll get data from the QQQ worksheet, but if SPY is in the dropdown cell I'll get data from the SPY worksheet instead. Thanks Stan


This question generated 8 answers. To proceed to the answers, click here.

This thread is current as of April 15, 2018.


For more resources for Microsoft Excel