Hello All,
Here is the situation, I have two cells that work together or that i want to work together. Cell 1 hold a simple pull down menu with 3 options (Bond, LOC, CASH). Now Cell 2 is currently blank but what i want it that if Cell 1 says Bond, adds a drop down menu made from column C from a sheet named "BONDING AGENCIES", if Cell 1 says LOC then i want it to do a drop down menu from column C from a sheet named "LOC AGENCIES" and if Cell 1 says CASH then cell 2 says "N/A".
Please let me know if this is possible.
Here is the situation, I have two cells that work together or that i want to work together. Cell 1 hold a simple pull down menu with 3 options (Bond, LOC, CASH). Now Cell 2 is currently blank but what i want it that if Cell 1 says Bond, adds a drop down menu made from column C from a sheet named "BONDING AGENCIES", if Cell 1 says LOC then i want it to do a drop down menu from column C from a sheet named "LOC AGENCIES" and if Cell 1 says CASH then cell 2 says "N/A".
Please let me know if this is possible.