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 data set of 26000 rows, and every time it finds the text: "Item Totals:" it should copy the value that is in the cell below it and paste it in column A in the cell below that for as many times until it finds another "Item Totals:" Sounds confusing, but hopefully the illustration below can clarify that. Many thanks for all your help!
Example:
A B
1 Items Totals:
2 5
3 Blank
4 Blank
5 Blank
5 Item Totals:
6 3
7 Blank
8 Blank
Should look like this when done:
A B
1 Items Totals:
2 5
3 5 Blank
4 5 Blank
5 5
6 Item Totals:
7 3 Blank
8 3
Example:
A B
1 Items Totals:
2 5
3 Blank
4 Blank
5 Blank
5 Item Totals:
6 3
7 Blank
8 Blank
Should look like this when done:
A B
1 Items Totals:
2 5
3 5 Blank
4 5 Blank
5 5
6 Item Totals:
7 3 Blank
8 3