View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?