referencing a sheet in a list box

  • Thread starter Thread starter Dave_Russell
  • Start date Start date
D

Dave_Russell

I have a workbook in which I need to keep records for many people.
want to have a sheet for each person. One sheet would serve as
report form to extract certain data from the selected person's sheet.

It would be ideal if I could use a list box to select the name of th
person, which would then tell the form which sheet to pull the dat
from. It would also be ideal if there was a way to have the names i
the list box generated from the existing sheet names so it would b
accurate as people are added to the workbook.

I found a way to generate the name of the sheet in a cell, but no wa
for excel to then treat it as a reference to that sheet. It onl
treats it as text.

Am I asking for the moon or is it possible? I am guessing I will hav
to explore the world of user created functions or something like that.
Can anyone help?

Dave Russel
 
you say you already have the sheet name in a cell. have you tried the
indirect function to get excel to treat the sheet name as a reference?
For example, if I have the word: SHEET1 in cell b5 and I want a cell
in sheet2 to equal b1 from sheet1 then I enter the following in that
cell
INDIRECT(B5&"!b1")
 
Back
Top