+ Reply to Thread
Results 1 to 3 of 3

Match data and copy to other sheet

  1. 05-17-2012, 03:20 PM #1
    mrcois
    mrcois is offline
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    Match data and copy to other sheet

    I have a Master sheet with all the data on. The other sheets need to scan the master sheet and match the data, then copy the rest of the data...

    PLEASE see attached file for better explanation...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-17-2012, 08:25 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Match data and copy to other sheet

    The attached workbook does this for you - formulae have been copied down to row 20, but you can copy them further if you have more data.

    Hope this helps.

    Pete
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-18-2012, 01:28 AM #3
    mrcois
    mrcois is offline
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    Re: Match data and copy to other sheet

    That worked 100%. THANKS MAN!!! Much appreciated...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1