Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Data from cell to another sell in differant sheets
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Data from cell to another sell in differant sheets
Enter this formula in A1 of Sheet2:
=IF(Sheet1!A1="","",Sheet1!A1) You can also put the same formula in Sheet3 and Sheet4. The formula can be copied to any other cell to bring the appropriate data from Sheet1 (but not any formatting you might have set up on Sheet1). Hope this helps. Pete On Oct 12, 6:39 pm, 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Data from cell to another sell in differant sheets
Hold the Shift key and click on Sheet 4 will hight all four sheets. then type
in sheet 1 it will copy on all sheets. "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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Data from cell to another sell in differant shee
thank you for your responce, I can do multiple cells at one time or would I
have to do this one at a time? "Kevin B" wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Data from cell to another sell in differant shee
yes this does however, If i wanted to copy multiply cells at one time, can
this be done in other words sheet 1 cells A1: A41 copy to sheet 2 B1:B41 "Pete_UK" wrote: Enter this formula in A1 of Sheet2: =IF(Sheet1!A1="","",Sheet1!A1) You can also put the same formula in Sheet3 and Sheet4. The formula can be copied to any other cell to bring the appropriate data from Sheet1 (but not any formatting you might have set up on Sheet1). Hope this helps. Pete On Oct 12, 6:39 pm, 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto populate an invoice from data in an existing worksheet | Excel Discussion (Misc queries) | |||
Can a macro - auto populate sheets... | Excel Discussion (Misc queries) | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Referancing differant sheets | Excel Worksheet Functions | |||
Auto Populate a cell | Excel Discussion (Misc queries) |