Find RMA Number and paste the order number and date multiple times

Hi Excel gurus,

I would like to automate one of the daily routines:

I would like to enter the RMA Number into cell A2, Order Number B2 and Date C2 and then after pressing Update i need macro to find RMA Number from cell A2 in range B6:B35 and copy and paste the Order Number from B2 and Date from C2 into adjacent cells C and D as many times the RMA Number is listed.

I have attached the example spreadsheet below.

Thank you in advance.

I cannot correlate your write up to the file you have uploaded. The cells and descriptions do not jive for me. You fail to mention which sheets contain which information. Very confusing. Suggest you review and try and write a clearer description that lines up with the file.

Try this:

Please Login or Register  to view this content.