Ever faced the problem where people make changes or remove crucial information (*by mistake*) which is then lost forever when they go and save the workbook?
In this tutorial we look at a simple line of VBA script that allows us to locate the last row of our data set and implement this with a copy & paste routine.
In this video we take a look at using "For Loops", this simple yet effective piece of VBA script gives us the ability to automative repetitive tasks / code such as populating a Column or Row of cells.
In this video we take our new calculator further making it more advance and enabling the user to also provide the symbol for their desired calculation.