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.

AttachmentSize
Cheque-Example.xls17.5 KB

how can i copy just a part of

how can i copy just a part of the cell not the whole cell??

Nick's picture

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