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 wrote:

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