I want to set up a drop down that includes information from column A & column B, is this possible?
N nanpenguin Feb 2, 2006 #1 I want to set up a drop down that includes information from column A & column B, is this possible?
A Arvi Laanemets Feb 3, 2006 #2 Hi nanpenguin said: I want to set up a drop down that includes information from column A & column B, is this possible? Click to expand... Only using a helper column (you can hide it later).
Hi nanpenguin said: I want to set up a drop down that includes information from column A & column B, is this possible? Click to expand... Only using a helper column (you can hide it later).
P paul Feb 3, 2006 #3 you dont say what sort of information or what sort of combination,but to start you cpild have another cell,where you have =A1&B1 and copy down and so in your drop down list refer to this range
you dont say what sort of information or what sort of combination,but to start you cpild have another cell,where you have =A1&B1 and copy down and so in your drop down list refer to this range
