View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 244
Default 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