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' ?????