Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell with data from another worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell with data from another worksheet
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell with data from another worksheet
Is lack of response an indicator that this cannot be done in excel?
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell with data from another worksheet
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cell with data from another worksheet
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 "Bob I" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
Populate cell with Worksheet name | Excel Discussion (Misc queries) | |||
how do I populate a cell with data from another worksheet, | Excel Discussion (Misc queries) | |||
how do I populate a cell with data from another worksheet, | Excel Discussion (Misc queries) | |||
How to populate a cell with the name of the worksheet it is in | Excel Discussion (Misc queries) |