I have two objectives, reformat a spreadsheet and calculate the value of the '1's and '2's. But the user inserts the '1's and '2's after the reformatting of the spreadsheet, which is apart of the macro. So there are no numbers before I run the macro. If the numbers were already given before I ran the spreadsheet Id know how to do that:

Dim row As Integer Dim oeValue As String row = 5 While Not IsEmpty(Cells(row, 4)) If Cells(row, 5) = "1" Then oeValue = oeValue + Cells(row, 4).value Else row = row + 1 End If Wend

But now should I set a cell where the total will be to sum up the '1' values once entered? I dont know how to do that.

Is there a way to "pause" the macro so the user can insert the numbers? Will I have to make two separate macros?

Columns:

D/4 = values

E/5 = numbers the user inserts, either a 1 or 2