Copy a row of data which is based on a value, in Excel, not VB

Mike - Sep 22, 2016 at 02:01 PM

I have a worksheet which has current data listed by Item numbers, description, quantity, plan, paid, amount, unit price. I would like to create a macro which will copy all like Item numbers and associated information in that particular row together on the same worksheet.