Hi I was wondering if someone could help me with an excel problem.
I have a workbook with a number of worksheets and I'd like to automate a copying process. What I need to do is when I select an option from a drop down box for a particular row, I'd like to copy the contents of cell A for that particular row to cell A in a new row on another worksheet.
Any help would be greatly appreciated.
