| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro or Formula to merge data
Downloaded Data format................
Column A.ColumnB..Column C.column D..Column E.Column F ..1item #.........qty expectpurch ord#.....<blank.<blank..<blank ..2..DescriptionQty recd<blankUnit Price..Ext PriceUnit of Meas (Wish list) ..Col A..........Col B....Col C.........Col D...........Col E..Col F..Col G ..3..Item#....DescriptionQty Recd.PO#...Unit of Measure..Unit priceExt. 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Permanently merge cells with text data w/o a formula? | Excel Discussion (Misc queries) | |||
| Merge cells with formula or macro? | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
Threaded Mode
