Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
How do I input data on one worksheet and have it appear on the next four
sheets? Copy and Paste is tricky between sheets and forgets itself if I dawdle. Is there a way to do that instead of re-entering all of it again? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
You can put this formula in A1 of Sheet2:
=IF(Sheet1!A1="","",Sheet1!A1) and then you can copy it across and down to suit your requirements. You can do the same for the other 3 sheets. It will not copy the formatting, though (you can't do that with a formula). Hope this helps. Pete On Sep 21, 1:22*am, bigonlif wrote: How do I input data on one worksheet and have it appear on the next four sheets? *Copy and Paste is tricky between sheets and forgets itself if I dawdle. * Is there a way to do that instead of re-entering all of it again? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
will it copy to result of a fomula?
"Pete_UK" wrote: You can put this formula in A1 of Sheet2: =IF(Sheet1!A1="","",Sheet1!A1) and then you can copy it across and down to suit your requirements. You can do the same for the other 3 sheets. It will not copy the formatting, though (you can't do that with a formula). Hope this helps. Pete On Sep 21, 1:22 am, bigonlif wrote: How do I input data on one worksheet and have it appear on the next four sheets? Copy and Paste is tricky between sheets and forgets itself if I dawdle. Is there a way to do that instead of re-entering all of it again? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
While we are at it......if I change the number on sheet one will it
automatically update the rest of the sheets? "Pete_UK" wrote: You can put this formula in A1 of Sheet2: =IF(Sheet1!A1="","",Sheet1!A1) and then you can copy it across and down to suit your requirements. You can do the same for the other 3 sheets. It will not copy the formatting, though (you can't do that with a formula). Hope this helps. Pete On Sep 21, 1:22 am, bigonlif wrote: How do I input data on one worksheet and have it appear on the next four sheets? Copy and Paste is tricky between sheets and forgets itself if I dawdle. Is there a way to do that instead of re-entering all of it again? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
It should update automatically to all the sheets that you entered the formula the poster above gave you. "bigonlif" wrote: While we are at it......if I change the number on sheet one will it automatically update the rest of the sheets? "Pete_UK" wrote: You can put this formula in A1 of Sheet2: =IF(Sheet1!A1="","",Sheet1!A1) and then you can copy it across and down to suit your requirements. You can do the same for the other 3 sheets. It will not copy the formatting, though (you can't do that with a formula). Hope this helps. Pete On Sep 21, 1:22 am, bigonlif wrote: How do I input data on one worksheet and have it appear on the next four sheets? Copy and Paste is tricky between sheets and forgets itself if I dawdle. Is there a way to do that instead of re-entering all of it again? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic data transfer
The easiest way of getting answers to these questions is to try it out
- the answer is Yes. Pete On Sep 21, 1:58*am, bigonlif wrote: While we are at it......if I change the number on sheet one will it automatically update the rest of the sheets? "Pete_UK" wrote: You can put this formula in A1 of Sheet2: =IF(Sheet1!A1="","",Sheet1!A1) and then you can copy it across and down to suit your requirements. You can do the same for the other 3 sheets. It will not copy the formatting, though (you can't do that with a formula). Hope this helps. Pete On Sep 21, 1:22 am, bigonlif wrote: How do I input data on one worksheet and have it appear on the next four sheets? *Copy and Paste is tricky between sheets and forgets itself if I dawdle. * Is there a way to do that instead of re-entering all of it again?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
Automatic transfer of data from one worksheet to another | Excel Discussion (Misc queries) | |||
vb code - Automatic transfer of data from one sheet to another | Excel Worksheet Functions | |||
vb code - Automatic transfer of data from one sheet to another | Excel Worksheet Functions | |||
Automatic transfer of cell details | New Users to Excel |