MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help please?

Posted by Tammy on September 23, 2001 1:52 PM

I have 2 worksheets. Sheet 'A' contains all input data, sheet 'B' uses the data to reorganise into new data ranges.

What I would like to do is possibly name the data or ranges in 'A' and when I come to type/organise the data in column A of sheet 'B' a drop-down menu should appear giving all column A options. Once a selection is made from the drop-down menu, all data on the same row of my selection from sheet 'A' is automatically filled-in for my chosen row in sheet 'B' ?????

Posted by Qroozn on September 23, 2001 3:09 PM

How many options are you planning on having in column A?
I am only a nvoice on excel but you can do data validation (ref to "sheetA!"),
then you can use if statements to fill in the other cells(this works upto about 8 if statements. you can always do it as a vlookup if there are more options than this.

Posted by Richard S on September 23, 2001 3:19 PM


You can use hlookup on your sheetB to return the values from the specified column in sheetA. If you use data validation on sheetB, this will ensure data integrity. It's a bit difficult ot explain, so I am sending you a example.