+ Reply to Thread
Results 1 to 3 of 3

Inputing/Arranging Data Across Multiple Sheets

  1. #1
    Registered User
    Join Date
    09-03-2007
    Posts
    4

    Inputing/Arranging Data Across Multiple Sheets

    I have a group of stores which I need to input into Excel. I would like to format the input data on multiple sheets in different manners.

    For example:

    I receive reports with the following fields (each -- represents a different cell):

    Store Name - Number - city - state - zip - owner - tel - fax - e-mail
    John's Food - 12345 - lima - oh - 21445 - Smith, John - ## - ## - **

    What I would like is, when I input the data on sheet 1, to have the data entered on other sheets in a different manner.

    For example, on sheet 2 I might only want the store name and telephone.

    On sheet 3, I might only want the person's name and e-mail, etc.

    I would also like to figure out how a change made on sheet 1 would be able to effect a change on sheets 2 and 3, etc.

    Any help would be greatly appreciated!!

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning jim_dickey

    You don't actually need to represent the information on several sheets as all the information is already there. Just set up several views of the same information set. Use Format > Column > Hide to hide the columns you don't want to see in a view, then go to View > Custom Views and click Add to set it up as a view.

    This way also negates the need to have the other sheets self updating from the first.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    09-03-2007
    Posts
    4

    Thanks!!!

    Works Perfect

+ 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