How to copy data in excel

Closed
raj - Apr 25, 2010 at 08:42 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 09:15 PM


hi,

Can any1 explain how to copy the entire row from one sheet to another if there is a matching. Example, copy all data with the machine num 'NC29' to a specific sheet for 'NC29'.

Thanks

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 25, 2010 at 09:15 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.

You can record macro to see how to do copy. On the surface it seem, that you would like to filter on NC29 and post the data to your sheet NC29.

This can give you a lot of help https://ccm.net/forum/affich-317037-macro-for-array-vlookup-to-worksheet
0