+ Reply to Thread
Results 1 to 5 of 5

going down the list

  1. #1
    Registered User
    Join Date
    09-02-2014
    Location
    Bay Area, CA
    MS-Off Ver
    2013
    Posts
    53

    going down the list

    Hi There, Is there a way to lookup Customer in A1 in sheet 2 and return ALL result to sheet 3, once complete for that customer move on to customer in A2 and show all results from Sheet2 on sheet 3..... so on and so forth?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: going down the list

    I'm sure there is, a long convoluted macro.

    Or you could simply copy all the data to Sheet3 as a whole then sort Sheet3 by Column A to get the same result with no macro.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-02-2014
    Location
    Bay Area, CA
    MS-Off Ver
    2013
    Posts
    53

    Re: going down the list

    then I would have to delete a whole lot of information. This is a report with thousands of rows and about 10 columns. I am just trying to extract the information I need for a new report.

  4. #4
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: going down the list

    I think you could probably adapt the code AB33 presents in Post #19 in this thread:

    http://www.excelforum.com/excel-prog...r-sheet-2.html

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: going down the list

    Your question in post #1 does not imply any leaving of ANY information out, you indicated wanting to parse together ALL the rows for ALL the unique column A values and list them together on a new sheet. That is accomplished by simply SORTING the data a whole, then you can quickly delete the columns you don't really want.

    You'll need to present a much clearer picture of what you want, so far your question does not exclude anything. So for now I think I'm right and perhaps if you try it, you'll discover it's only 60 seconds of work after all.

    If not, post a workbook demonstrating how it's not as easy as what I've said. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-22-2015, 11:40 AM
  2. Replies: 3
    Last Post: 04-22-2014, 03:30 PM
  3. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  4. [SOLVED] Taking a list of tasks and a list of subtasks and creating a new list with groupings
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2012, 12:16 PM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM

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