hi,
i have a main sheet.....and several other sheets.....
in my main sheet, i have a formula like this:
=* *B7
i then would like to have a combo box where i could select the sheet name and * * would be filled with that sheet....so that B7 is looked up from that particular sheet! does that make sense to anyone?
so that if the user choses sheet5, the formula becomes =(sheet5!B7)
please help!
i have a main sheet.....and several other sheets.....
in my main sheet, i have a formula like this:
=* *B7
i then would like to have a combo box where i could select the sheet name and * * would be filled with that sheet....so that B7 is looked up from that particular sheet! does that make sense to anyone?
so that if the user choses sheet5, the formula becomes =(sheet5!B7)
please help!