+ Reply to Thread
Results 1 to 3 of 3

Find exact match then copy table

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2013
    Posts
    9

    Find exact match then copy table

    Hello,

    I would need a help with (i guess) simple macro. I have 2 sheets in a workbook - Source data and Weekly data.

    On the sheet "source data" I have simple function to determine number of week when is report created. Then there is a table (which is result of advanced filter - each week it has different amount of records (rows), but still the same format (columns F-I).

    On the "weekly data" sheet I have created the heading including the number of week and the same data as the table from the sheet "Source data" (columns F-I) but for whole year (52 weeks for 2016).

    What I need is probably obvious now. I need to run a macro that based on the number of week (changing automatically each week) from "Source data" is looking for the number of week in "Weekly data" and when it finds it, copy the data from "Source data" below the heading with found number in "Weekly data".

    File attached for reference.

    Thank you guys for any tips, help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,131

    Re: Find exact match then copy table

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-06-2013
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: Find exact match then copy table

    Thank you very much Leo, it works.

+ 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. add in the parameters to the Find function to only find an exact match.
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2014, 08:57 AM
  2. [SOLVED] Problem with Find function. Need to find Exact match
    By SMILE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 07:07 AM
  3. [SOLVED] Find and copy exact match across multiple worksheets
    By sandeepafpl in forum Excel General
    Replies: 2
    Last Post: 08-17-2012, 09:19 AM
  4. Find exact match in two collumn. Please help
    By 11ktran44 in forum Excel General
    Replies: 1
    Last Post: 02-23-2012, 04:00 AM
  5. Find exact match
    By indimonk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2012, 11:25 PM
  6. [SOLVED] Find exact match.
    By Robert.Cordani@us.schneider-electric.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2006, 12:55 PM
  7. Find a not exact match using vlookup
    By Russ B in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 04:05 PM
  8. using vlookup to find exact match
    By Janice Lee via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 03-24-2005, 10:46 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