Taking information from one page and having it automatically
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Taking information from one page and having it automatically

  1. #1
    New Member
    Join Date
    Jan 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to take information from one sheet and have it print directly to other sheets so I don't have to copy and paste. Example:
    Information Sheet
    Name: John Smith
    Address: 1234 Main Street

    Sheet #1
    John Smith in the name cell
    1234 Main Street in the address cell
    and so on.

    Please understand, I am not real sharp at this but I would love to learn how to accomplish this. I write sales contracts and having to repeat, over and over the name and address and so on is time consuming.

    Please help if possible.
    Thanks,
    Gordon

  2. #2
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If the information goes into the same cell on every sheet, select all the sheets at once. When you type the info in the first sheet, it will be copied in all of them.

    To select all sheets, click the first one, hold down the Shift key and click the last one.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com