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

  • Thread starter Thread starter shellyjohnson
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

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

info mtg criteria from one wkbk to another 2
How copy automatically from one sheet to another. 4
Series fill only copying and fill series greyed out 1
Formula to copy data in one sheet to another 8
Copy data from unlocked cells 3
In 3 active sheets in wkbk, determine& display the # of sheets that have data 1
Auto-filling cells from another sheet 1
Insert row automatically when row intersted on another sheet in same wkbk 0

Back
Top