ChrisParks
Technical User
Hey all,
wondering whether any of you know if it is possible to do the following
have a drop down that has say 2 options
each option represents the name of a sheet on the current workbook
the contents of each sheet are identical, but depending on the situation, you may want to retrieve data from one sheet or the other
so for example, lets say that we want to refer to cell b12
is there a formula that would do the following?
=??(sheetname&B12)
where sheetname is the output from teh dropdown box and is text that equates to the sheet name
address and indirect do not seem to be the solution
appreciate any help you guys can give me. thanks!
wondering whether any of you know if it is possible to do the following
have a drop down that has say 2 options
each option represents the name of a sheet on the current workbook
the contents of each sheet are identical, but depending on the situation, you may want to retrieve data from one sheet or the other
so for example, lets say that we want to refer to cell b12
is there a formula that would do the following?
=??(sheetname&B12)
where sheetname is the output from teh dropdown box and is text that equates to the sheet name
address and indirect do not seem to be the solution
appreciate any help you guys can give me. thanks!