My apologies for not saying it earlier - Welcome to VBAX
And yes I would like to help you, I just need some more information about your problem. I would like to know If you want to place the "new" answer when you redo your calculation into the column next to old one (same row different cell Eg 1st answer in A1, next answer in B1) or into the row below (same column, different row Eg 1st Answer A1, next answer A2 etc) on sheet two? Because there are two ways of looking for the next empty cell, either by column or by row.
Dim LastColumn As Integer
LastColumn = Range("A1").Column.End(xlRight)
Range("A"&(LastColumn+1)).Value = NewAnswer
Or
Dim
LastRow As Integer
LastRow = Range("A65536").Row.End(xlUp)
Range("A"&(LastRow+1)).Value = NewAnswer