Entering data into more than one worksheet

A

artemisia

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 ;
 
C

chris

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 ;
 
C

chris

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 ;
 
A

artemisia

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. :
 
W

W.J.Surrarrer

artemisia said:
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 ;)
Click to expand...

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.
 
C

chris

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. :
 
W

W.J.Surrarrer

artemisia said:
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. :)
Click to expand...

Try the following:
=if(Sheet1!B2="","",Sheet1!B2), again replace sheet1 name and B2 with
your references
 
Top