+ Reply to Thread
Results 1 to 3 of 3

Worksheets

  1. #1
    Acrumly
    Guest

    Worksheets

    I have a file that I have to fill out for one of our buyers and it has two
    sheets to it. Some of the information that I enter on one worksheet can also
    be entered onto the 2nd worksheet. What can I change so that when I enter
    the info on one sheet, it automatically transfers to the 2nd sheet?

  2. #2
    Registered User
    Join Date
    03-15-2004
    Location
    OR, USA
    Posts
    51
    Quote Originally Posted by Acrumly
    I have a file that I have to fill out for one of our buyers and it has two
    sheets to it. Some of the information that I enter on one worksheet can also
    be entered onto the 2nd worksheet. What can I change so that when I enter
    the info on one sheet, it automatically transfers to the 2nd sheet?
    Try something like this assuming you are in sheet 2 and you want something from sheet 1.

    =Sheet1!B4

  3. #3

    Re: Worksheets

    If you want the information to be entered in the second worksheet in
    the same cell as in the first worksheet,
    Select both the worksheets and type the value

    If you want the value to change in the second worksheet as and when you
    change the value in the first worksheet use the pastelink option in the
    edit<pastespecial menu


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1