| Home |
| Search |
| Today's Posts |
|
|
|
#1
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? |
|
#2
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) | |||
Hybrid Mode
