+ Reply to Thread
Results 1 to 7 of 7

Listing random lines from different Tabs onto 1 Tab

  1. #1
    Registered User
    Join Date
    08-29-2007
    Location
    Sydney, Australia
    Posts
    6

    Listing random lines from different Tabs onto 1 Tab

    Ok, here is a beauty.
    Please look at the attached file for more info.
    I have four Blue Tabs and six Red Tabs on a spreadsheet.
    The project is simple. The Blue Tabs are the source data and the Red Tabs are the result areas.

    Each Blue Tab has a column called "Supplier" ($C$).
    Each Red Tab is dedicated to a "Supplier" which includes all the relavent information

    All I want to know is what is the command to all the information from each line of a supplier (from all the blue tabs) to list into their respective red supplier tab.

    IE: On the 5 Blue Tabs there will be many lines for a Supplier called Purax. I need all those lines relating to Purax on the 5 Blue Tabs to re-display on the one Red Purax Tab.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    I don't believe that there is any "command" to do this easily. To me this is something that will have to be done by a macro.

    Is this a viable solution alternative?


    rylo

  3. #3
    Registered User
    Join Date
    08-29-2007
    Location
    Sydney, Australia
    Posts
    6

    Thank God there is someone there.

    Dear Rylo,
    Thanks for your reply.
    I have been trying to do this on and off for about two months and if you tell me that a macro is the only way, then so be it. If you told me I had to jump through a hoop while singing Jingle-Bells I would think that was a little strange but so be it.

    Can you help me with the macro?

    Many Thanks
    Matthew Scarf
    Sydney, Australia

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Matthew

    Is there any chance that the "Blue tab" sheets can be modified so that they have consistent headings / columns? At the moment, there are some differences.


    rylo

  5. #5
    Registered User
    Join Date
    08-29-2007
    Location
    Sydney, Australia
    Posts
    6

    Anything you want

    Well thatís a surprise. They were meant to be the same. Yes go ahead. Change it any way you want.

    Matthew

  6. #6
    Registered User
    Join Date
    08-29-2007
    Location
    Sydney, Australia
    Posts
    6

    Smile Reply

    Dear Rylo,
    You have just moved up to be my favourate person in the whole world.

    My email address is m.scarf@scarf.com.au

    Many thanks in advance for your help.

    Matthew Scarf

    PS: what country do you come from.

  7. #7
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Matthew

    I've just sent you a copy of the file. It would pay to remove your email address from the general view area. Too many ways to attract SPAM.


    rylo

+ 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