Details: Excel 2007 on Windows XP
I'm looking for help in creating a drop down (data validation) on SheetX!B2, with options from Column B on SheetY or SheetZ where Column A on SheetY or SheetZ matches SheetX!A2. That is the problem in word form but I'm also providing an attachment of the spreadsheet described:
I've gotten close to success but not quite there.
Any solutions??
Thank you.
I'm looking for help in creating a drop down (data validation) on SheetX!B2, with options from Column B on SheetY or SheetZ where Column A on SheetY or SheetZ matches SheetX!A2. That is the problem in word form but I'm also providing an attachment of the spreadsheet described:
I've gotten close to success but not quite there.
Any solutions??
Thank you.