Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
I need your help!
I need to create a workbook of order froms (six sheets total), and want to only enter the customer information on the first sheet and hav it automatically be entered into the other five sheets. This would b the top 1/4 part of each sheet. The rest of each sheet would be totall different and information would be added directly into each sheet. How would I go about creating such a workbook? *Is this possible?* Thank you for your assistance ; -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
Just Copy The area on the first worksheet to all other subsequent worksheets using these steps
Copy PasteSpecial PasteLink Now whatever you put in the first will show up in the other ----- artemisia wrote: ---- I need your help! I need to create a workbook of order froms (six sheets total), and want to only enter the customer information on the first sheet and hav it automatically be entered into the other five sheets. This would b the top 1/4 part of each sheet. The rest of each sheet would be totall different and information would be added directly into each sheet. How would I go about creating such a workbook *Is this possible?* Thank you for your assistance ; -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
Copy the area you want to the other sheets using these step
Copy PasteSpecial PasteLink ----- artemisia wrote: ---- I need your help! I need to create a workbook of order froms (six sheets total), and want to only enter the customer information on the first sheet and hav it automatically be entered into the other five sheets. This would b the top 1/4 part of each sheet. The rest of each sheet would be totall different and information would be added directly into each sheet. How would I go about creating such a workbook *Is this possible?* Thank you for your assistance ; -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
That worked. Yeah!
Now...is there a way to get rid of the 0 in all the empty field without eliminating the formula or do that have to stay there? I would rather not see them when the forms are printed. Thanks again for your help. : -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
artemisia wrote in message ...
I need your help! I need to create a workbook of order froms (six sheets total), and I want to only enter the customer information on the first sheet and have it automatically be entered into the other five sheets. This would be the top 1/4 part of each sheet. The rest of each sheet would be totally different and information would be added directly into each sheet. How would I go about creating such a workbook? *Is this possible?* Thank you for your assistance ;) --- Message posted from http://www.ExcelForum.com/ I may be over simplifying, but wouldn't the following work? =Sheet1!B2 entered into the destination cells. It uses the value in cell B2 on Sheet1 in whatever cell it is entered in. You would need to replace Sheet1 with whatever your sheet name is and B2 with whatever your cell reference is. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
Tools Options View: remove check from 'Zero Values
----- artemisia wrote: ---- That worked. Yeah! Now...is there a way to get rid of the 0 in all the empty field without eliminating the formula or do that have to stay there I would rather not see them when the forms are printed Thanks again for your help. : -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
artemisia wrote in message ...
That worked. Yeah! Now...is there a way to get rid of the 0 in all the empty fields without eliminating the formula or do that have to stay there? I would rather not see them when the forms are printed. Thanks again for your help. :) --- Message posted from http://www.ExcelForum.com/ Try the following: =if(Sheet1!B2="","",Sheet1!B2), again replace sheet1 name and B2 with your references |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering data into more than one worksheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering footnotes in worksheet | Excel Discussion (Misc queries) | |||
entering data from one worksheet to another | Excel Discussion (Misc queries) | |||
Automatic entering of information from another worksheet if given | Excel Worksheet Functions | |||
Entering information from 1 worksheet to another, if criteria is m | Excel Discussion (Misc queries) | |||
Entering the same data on more than one worksheet | Excel Worksheet Functions |