+ Reply to Thread
Results 1 to 2 of 2

copying data from source workbook to target workbook by headers

  1. #1
    Forum Contributor
    Join Date
    05-22-2006
    Posts
    103

    copying data from source workbook to target workbook by headers

    hi,

    im creating this macro and the only thing that is missing is for me to be able to copy the top10 and last 10 data of the filtered column from the source workbook to the target workbook by the use of its header as a reference.

    please see attached.

    help is greatly appreciated.

    thank you...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: copying data from source workbook to target workbook by headers

    tweety127,

    Your posted workbook contains a header row, row 1, and only two rows of data.

    Top 10 and bottom 10 will need more than 20 rows to play with.

    What column are you filtering on?

    Please post another workbook with more information, your macro, and more detailed instructions.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ 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