Is there a way to code "Bid Calculator (C29:G29)" the number in the last cell before G29 example [c29 is 1, D29 is 2, E29 is 3], and F,G are blank.
and add the cell E29 is 3 to this [CODE]With Sheets("Legend").Range("R4")
.Value = .Value + 1[CODE/]
Lets say R4 gives the number 4 and E29 is...