Referencing problem
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Referencing problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Kent, the Garden of England, that no one has bothered to weed.
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Afternoon All. I have a real nasty I need a solution for.

    A spreadsheet has four sheets, one per region, each of these sheets lists employee id numbers, each employee has an id number for each sales area, some id numbers are the same in different sales areas. This is the sheet I need to populate from the following:

    Spreadsheets for each area (twelve areas)listing the employee id number and the number of sales they have achieved for different product types.

    How do I get the data from my 'area' sheets to my 'region' sheets ensuring that the correct data referenced to the employee id number goes to the correct 'region' sheet.

    You help would be gratefully appreciated

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    IMHO...

    First thing you need to do is get all the area sheets into one sheet. Then you get all the region sheets into another sheet. Your region sheet should contain summary information of all your area sheets. Use Autofilter, Grouping, and Subtotals (all under the Data menu) to perform the *separations* of data that you're now performing by using separate sheets.

    See my little do-up on file layout for using Excel as a database:

    http://www.thewordexpert.com/excel.h...utForDatabases

    Let me/us know if you need more help from there.
    ~Anne Troy

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Kent, the Garden of England, that no one has bothered to weed.
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have posted almost the same question again. I followed the link you gave and I have followed the conditions and text of that link. My spreadsheet(s) comply. My second posting, I believe, explains my problem a little clearer. I would like to avoid putting everything into one sheet, as it takes just as long to strip out the data i need to ignore, then to sort it then to reference the employee id to the manager.
    Can you suggest anything further?
    Regards.

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Actually, did you try the features I've mentioned? Why would it be more difficult to *strip out* the data? The thing is, you don't have to strip it out. By using autofilter, you can choose to view only the data from a specific branch. Perhaps you need to check into these features further. It seems as though you do not understand how they work. If you'd like to send your file so I can give you an example as to how I see your file working, feel free. Dreamboat@TheWordExpert.com
    ~Anne Troy

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