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.
Thanks Rachelle.
Attachment | Size |
---|---|
Cheque-Example.xls | 17.5 KB |
how can i copy just a part of
how can i copy just a part of the cell not the whole cell??
Cheque example
Here's how to do it:
Cheque example
- to refer to another cell with a formula, simply type the formula: "=A3" in another cell.
Nick
Can this be done into another
Can this be done into another worksheet? I need to auto copy data from one worksheet to a cell on another worksheet. Is this possible?
copy
when type date one cell then copy automatic other cell