This always happens to me however the good thing is that the line 1 of every
data has a distinguishing title so that it actually reads "ITEM# nnnnn", so
what I do is I use that to indicate that is the leading line

If data starts in column A2, you can change the "ITEM" into the common word
or prefix for the leading data line.

In column G I used =IF(left(A2,4)="ITEM",A3,G2) Then in Column H
=IF(left(A2,4)="ITEM",B3,H2)

It is a bit more simplistic but it will work as long as you are dumping the
data from a report.



"CandiC" wrote:

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?