I have a workbook with several worksheets in it. On the first sheet is the main data and a drop down list. What i need to do is when a selection is made using the drop down list, look down column A in sheet1 and if the value of the first cell matches the selection made in the drop down list, then copy the entire row to the next available row on sheet2.
Is this possible? Any help or guidance would be much appreciated.
Lee.
Is this possible? Any help or guidance would be much appreciated.
Lee.