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