Populate cell with data from another worksheet

[FP Novice]

I would like to flag a cell with an A for active or I for inactve (lets say
cell A1) and based on the entry have another cell (G1) populate an entry
from another worksheet. The catch being that it will be dynamic in the sense
that the data retrieved can be reused if it ever becomes inactive again.

So, my dilema is when a A1 is marked active I not only want to populate the
cell with data from Sheet2 I also want the cell used on Sheet2 to be made
unavailable for future use. When A1 is marke inactive I want the
corresponding cell in Sheet2 made available again.

Thanks,
Todd

 

[FP Novice]

I would like to flag a cell with an A for active or I for inactve (lets say
cell A1) and based on the entry have another cell (G1) populate an entry
from another worksheet. The catch being that it will be dynamic in the sense
that the data retrieved can be reused if it ever becomes inactive again.

So, my dilema is when a A1 is marked active I not only want to populate the
cell with data from Sheet2 I also want the cell used on Sheet2 to be made
unavailable for future use. When A1 is marke inactive I want the
corresponding cell in Sheet2 made available again.

Thanks,
Todd

 

[FP Novice]

Is lack of response an indicator that this cannot be done in excel?

 

[Bob I]

Cells can only retrieve data. Is "G1" actually supposed to contain what
in in the other sheet or can it just be a link and show the value? A
macro could copy the value from the other sheet OR a link could Show
what is in the other sheet.

 

[FP Novice]

Well, I think you are correct that what I want to do may not be a function of
Vlookup. After a ton of reading and mucking around I think that a combo box
may be my solution. I have posted a seperate question titled 'combo box' in
Excel General.

I simply want to choose a logical ID from a list of 2048 for a port, and
once chosen have it made unavailable for future selection. In the reverse,
once no longer in use I want the logical ID placed back into the list...

Thanks Bob I