+ Reply to Thread
Results 1 to 10 of 10

Find cell value in column and copy to other sheet

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Find cell value in column and copy to other sheet

    HI I will continue with a new thread. The other or old is half done. So this subject line is more relevant. I need this last code to make all work


    In sheet1 cell G7. I have a value.

    I need to find that exact value(text) in Sheet "SavedRefunds" In column B.
    If important you add to only search in cells with color index .

    When i have found the exact value(text) I need this cell and the next 18 cells after that
    to be copied to Sheet "Refund" Range A1:A19

    Please have a look at the modified testsheet.

    thanks
    Abjac
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find cell value in column and copy to other sheet

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Find cell value in column and copy to other sheet

    HI John it works perfect. Is there any way to put in that it only have to search in the cells, which have a color index 6? together with the cell value off course?. Just to minimize the risk, that it will take a dublet. But the code works for sure.

    Sincerely

    Abjac

  4. #4
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Find cell value in column and copy to other sheet

    HI John it works perfect. Is there any way to put in that it only have to search in the cells, which have a color index 6? together with the cell value off course?. Just to minimize the risk, that it will take a dublet. But the code works for sure.

    Sincerely

    Abjac

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find cell value in column and copy to other sheet

    Try:

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Find cell value in column and copy to other sheet

    Hi John basically the code for this is also working. I was just fighting a little with the error, if i example write the same in the header in sheet "SavedReports" but put no color on it. It come with an errror, and i cant get it aways with the normal On Error GoTo 0.

    If you have time please try to have a look, why i cant get this error away.. Normally you can be putting this line in On Error GoTo 0.



    Sincerely

    Abjac

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find cell value in column and copy to other sheet

    Ok try:

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find cell value in column and copy to other sheet

    Ok try:

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Find cell value in column and copy to other sheet

    Thanks john it works like a charm. Thank you very much
    Really great

    Sincerely
    Abjac

    This a part of a bigger project. Here is the other link.

    http://www.excelforum.com/excel-prog...run-macro.html
    Last edited by abjac; 03-18-2013 at 12:35 PM.

  10. #10
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find cell value in column and copy to other sheet

    You're welcome. Glad to help out and thanks for the feedback.

+ 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