Yes! And thank you very much in advance for the suggestion to clarify.
What Im looking to do with the above script is to zero out the Transition To Bill "New Bill" field by aggregating/moving it into the "Billed" field by simply adding it to the formula for an updated calculation.
Heres the reasoning: When I want to create a current bill, i like to see (by peeking into the "Billed" field formula) what past billing amounts were to get a rough idea of how to bill the current period.
Good Day to All.
I am using the below code to try to add a New Value (Cell 4,4) to a pre-existing value (Cell 5,4) without erasing the string details. An example of the process is shown below:
Step 1
Step 2
What am I missing from this code? Because its not keeping all the previously entered values/string characters in place as I am adding a new number/value
Sub Concatenate2()
Dim String1 As String
Dim String2 As String
String1 = Cells(4, 4).Value
String2 = Cells(5, 4).Value
Cells(5, 4).Value = "=" & String1 & "+" & String2
Range("D4").Value = 0Much appreciated in advance!!!!