I dont have much experience with VBA but know this would be the best way to populate a long document.
If I have a value in column B beginning with cell B2 put the value "2019" in cell J2
Thats it!!
Additionally, i currently use a formula to remove all the data in a cell after a particular character ("!"), using the FIND and LEFT functions, can you add the same formula to VBA and replace the cell with the updated value?
thanks all
If I have a value in column B beginning with cell B2 put the value "2019" in cell J2
Thats it!!
Additionally, i currently use a formula to remove all the data in a cell after a particular character ("!"), using the FIND and LEFT functions, can you add the same formula to VBA and replace the cell with the updated value?
thanks all