Macro or Formula to merge data
Downloaded Data format................
€¦€¦Column A€¦.ColumnB€¦€¦..Column C€¦€¦.column D€¦..Column E€¦€¦.Column F
..1€¦item #.........qty expect€¦€¦purch ord#.....<blank€¦€¦.<blank€¦€¦€¦..<blank
..2..Description€¦Qty recd€¦€¦<blank€¦€¦€¦€¦Unit Price€¦..Ext Price€¦€¦Unit of Meas
(Wish list)
€¦..Col A..........Col B€¦....Col C€¦.........Col D...........Col E€¦€¦€¦..Col
F€¦€¦€¦..Col G
..3..Item#....Description€¦Qty Recd€¦.PO#...Unit of Measure..Unit price€¦Ext.
recd
This is a receiving report, I am trying to calculate total receipts per item
number, however, when I download the information from our MRP system I end
up with two rows of information. I need to merge the information in rows 1
and 2 keeping them in line(Wish list) , however, in Column B , I would only
like to state the total €śQuantity Recd€ť and delete the €śqty Expect.€ť Please
advise if this would need to be written as a macro. Can someone help me
please?
|