+ Reply to Thread
Results 1 to 4 of 4

Copying multiple Rows of Data based on a customer name

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Question Copying multiple Rows of Data based on a customer name

    Good Afternoon,

    I am creating a customer knowledge and communication database and creating a front page that the staff will use to select the customer.

    Then all the information on this customer will be pulled through from sheets behind. I have done most of the formulas as either Index, Match or Vlookup as most only have 1 set of data.

    I now need to get it to pull all issues from one sheet and all complaints from another. The issue i have is there could be multiple entries for each customer over the years and I need it to pull each one through.

    Has anybody got an idea how i could do this. My excel skills are very basic.

    Thank you in advance for your support.

    Kind Regards
    Lewis W

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Copying multiple Rows of Data based on a customer name

    Can you please post a sample file (nor image) showing expected results.

    To upload a file, click "Go advanced" (next to "Reply" button) then scroll down "Manage Attachments". Click on this, browse, select a file, Upload and Close window.

    It likely to be combination of INDEX/MATCH/SMALL to retrieve all data for a particular customer

    As an example

    =IFERROR(Index($B$2:$B$100,small(IF($A$2:$A$100=$X$2,row($a$2:$a$100)-row($a$2)+1,""),rows($a$2:a2))),"")

    Column B is data to retrieved

    Column A contains Customer Numbers

    X2 contains Customer number we are interested in

    The above formula has to be entered with CTRL+SHIFT+ENTER (Hold down CTRL and SHIFT keys) then ENTER

    Drag formula down column until (at least) you get a blank line

  3. #3
    Registered User
    Join Date
    02-18-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Re: Copying multiple Rows of Data based on a customer name

    Good Afternoon John,

    Thank you for your response. I have attached the file.

    If you have any further questions please let me know.

    Lewis
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Copying multiple Rows of Data based on a customer name

    The general form of the array entered formula* used in this solution is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Note: to use an array entered formula Merge and Center was changed to Alignment > Across the Selection.
    * Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let me know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. copying multiple rows based on column criteria
    By harrydnyc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2016, 06:08 PM
  2. [SOLVED] Copying entire rows to a different sheet based on multiple conidtions
    By WA Kiwi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2016, 08:00 PM
  3. Replies: 3
    Last Post: 09-26-2014, 01:07 AM
  4. [SOLVED] Copying Customer Details Onto Each Sale Line Until Next Customer is Reached
    By Babybio77 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2013, 11:33 AM
  5. [SOLVED] Merge mutliple rows of data based on customer number
    By theatergirl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 08:57 PM
  6. Copying Rows Based on Condition from Multiple Worksheets to 1
    By codyj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2011, 07:23 PM
  7. Replies: 1
    Last Post: 12-23-2006, 03:45 PM

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