Match Data on Another Worksheet and Copy/Paste Range

  • I know the basics of this can be done using INDEX MATCH or VLOOKUP, but I need the formatting of the cell (specifically the cell fill color) to match up with it. I have tried looking over many other posts in the forums, so I know this will require a VBA macro, but I am not even sure how to approach this or where to begin.


    I have worksheets Sheet1 and Import. There are IDs on Sheet1 in Col C and there are IDs on Import in Col A. I need the data (including the cell formatting) in Cols H:O copied from Import and pasted onto Sheet1 Cols H:O if the IDs match.


    Example Result: Cells Import!H8:O8 would be copied and pasted into cells Sheet1!H5:O5 because the IDs match between the 2 sheets.


    Sheet1
    [Blocked Image: http://www.ozgrid.com/forum/attachment.php?attachmentid=71750&d=1489424350]


    Import
    [Blocked Image: http://www.ozgrid.com/forum/attachment.php?attachmentid=71751&d=1489424352]


    Any help will be greatly appreciated.

  • Re: Match Data on Another Worksheet and Copy/Paste Range


    After some further digging around and tinkering with various solutions, I found a macro that I was able to minimally change to do what I need. Here is the solution I came up with in case someone else needs the answer. (Credit for macro: https://www.computing.net/answ…pypast-the-row/19831.html)



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!