I'm in need of a macro that will cut and paste contents of a cell based on the value of another cell. More specifically, this macro needs to evaluate each cell in column B for a value of "Item Totals:". Every time it finds the text: "Item Totals:" it should copy the value that is in the cell directly below it, and paste it in column A in the cell offset (-1,1) and each cell below that until it encounters another "Item Totals:" in Column B. Once the cut and paste is done, then it should delete the row that has "Item Totals:" in it and also the row below it that contains the value it is copying to column A. Sounds confusing, I know but hopefully the attached file can help clarify what I'm looking for. Many thanks for all your help!
Bookmarks