+ Reply to Thread
Results 1 to 16 of 16

Copy whole row if criteria matches one cell

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Copy whole row if criteria matches one cell

    Hi

    I am trying to get my spread sheet to copy over all information in one row if certain criteria is found in one cell.

    I have attached a workbook to show you what I mean.
    I need the information to feed into 'Commision' sheet if cell S in 'Shutters' workbook displays 'CASH'

    I am not good with forumalas and function so if you can help please keep the instructions simple

    thanks
    Hayley
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-17-2013
    Location
    banglore
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Copy whole row if criteria matches one cell

    Hi Hayley,

    The excelsheet you have attached it is password protected.

  3. #3
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    oops try SUMMER123

  4. #4
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    I saw this thread and figure its maybe what I need, but I dont understand the actual code and what exactly I need to do

    http://www.excelforum.com/excel-prog...-criteria.html

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    Qld, Australia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy whole row if criteria matches one cell

    test(1).xlsxI did some formulas, but I don't know how to only bring across cells with text. I am still waiting on someone to get back to me about it.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: Copy whole row if criteria matches one cell

    Please show the expected output in your file for suggesting exact code for your requirement


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  7. #7
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    I need it to copy all the row information over if the criteria matches

  8. #8
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Copy whole row if criteria matches one cell

    Hi.

    You can try this:

    test copydata.xlsm
    Click *, if my suggestion helps you. Have a good day!!

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: Copy whole row if criteria matches one cell

    Copy and paste the below code in standard module and return to excel and press Alt+F8 and select MatchAndGetData and Click Run.

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    01-17-2013
    Location
    banglore
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Copy whole row if criteria matches one cell

    Hello Dear,
    It is not working if it has some blank column Like K in this example.
    Else it is working :-)

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: Copy whole row if criteria matches one cell

    @ Swapnanjali,

    The message is for whom?

  12. #12
    Registered User
    Join Date
    01-17-2013
    Location
    banglore
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Copy whole row if criteria matches one cell

    It is only for sixthsense

  13. #13
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: Copy whole row if criteria matches one cell

    Yes, there should not be any break in column headers.

  14. #14
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    Sorry as I said I have very little knowledge of excel. By module do you mean cell?

  15. #15
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    Hi I managed to do this but it did not pull through all the information including total amounts etc. I removed the blank colum and then it didnt pull through the infromation except headers.
    Are you able to help?

  16. #16
    Registered User
    Join Date
    01-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Copy whole row if criteria matches one cell

    Sorry to make this more complicated. Can you get this to pull the information from a different excel file entirely?

+ 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