Auto copy exact data from one cell to another
Hi I am working on creating a cheque template for work and I need to know which formula to use that will copy data from the original cell I enter it into to mutliple cells on the worksheet.
I want to use this formula to decrease the amount of error that could possibly occur with the data entry. For example: If I type John Smith's name in the first box which will appear on the pay stub portion of the cheque template then I want it to copy onto the cheque as well. Or if I type the cheque number it needs to appear in at least 3 locations on the template.
I'd also like to know if there is a simple way to create a cheque template? Is there one already built into excel that I can just customize myself?
Please let me know how I can accomplish this.