Copy records in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1653233%22%20slang%3D%22en-US%22%3ECopy%20records%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1653233%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20was%20wondering%20if%20someone%20could%20help%20me%20with%20an%20excel%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20with%20a%20number%20of%20worksheets%20and%20I'd%20like%20to%20automate%20a%20copying%20process.%20What%20I%20need%20to%20do%20is%20when%20I%20select%20an%20option%20from%20a%20drop%20down%20box%20for%20a%20particular%20row%2C%20I'd%20like%20to%20copy%20the%20contents%20of%20cell%20A%20for%20that%20particular%20row%20to%20%26nbsp%3Bcell%20A%20in%20a%20new%20row%20on%20another%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1653233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

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.

 

0 Replies