copying

  • Thread starter Thread starter jwheeler
  • Start date Start date
J

jwheeler

How do you copy information automatically from one
worksheet to another worksheet within the same workbook.
I have customer order as one worksheet, production as the
second sheet and invoice as the third sheet. I want to
have the customer order information (name address etc)
populate the other two worksheets. Can someone identify
what this is called so I can look it up. I have been
unsuccessful in figuring this out.
 
J, could you just use a formula in the other sheets to show what's in the
customer order sheet, like this
='customer order'!A1 to show what's in A1 on you customer order sheet?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top