Auto Populate Data from cell to another sell in differant sheets
Just reference the cell in the first sheet in all the others.
if the value is in cell A1 in Sheet1 the following would do the trick:
=Sheet1!A1
Any change to the value in cell A1 of Sheet1 would be reflected automatically.
--
Kevin Backmann
"KrazyAmg" wrote:
I am working in a book with differant sheets, most the the data is the same
on 3 sheets that I am working on. Can I set up a formula or action so that
the data I type in one sheet in one cell can auto populate into the other 3
sheets in certain cells?
|