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
Tammy,
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.
Richard
