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

S

shellyjohnson

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!
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Copy data from unlocked cells 3
Formula to copy data in one sheet to another 8
How copy automatically from one sheet to another. 4
In Excel I need to insert a clean form each use 1
info mtg criteria from one wkbk to another 2
Absolute Cell refernce Not working 9
hiding formula in cell 2

Top