Copying cell info from one sheet to another in the same wkbk
 

I have 5 forms (all formatted differently) that need to be filled out for
each transaction. They all contain the same information. I would like to
fill out the first sheet and it automatically fill in the subsequent sheets.

Tired of forms!

Copying cell info from one sheet to another in the same wkbk
 

Use formulas in the subsequent sheets refering to the 1st sheet.

For example to get Sheet A1 value in Sheet A2
enter the formula in Sheet2 A2
=Sheet1!A1

If this post helps click Yes
---------------
Jacob Skaria


"shellyjohnson" wrote:

I have 5 forms (all formatted differently) that need to be filled out for
each transaction. They all contain the same information. I would like to
fill out the first sheet and it automatically fill in the subsequent sheets.

Tired of forms!