+ Reply to Thread
Results 1 to 3 of 3

Search multiple headings in other sheet, copy data and paste in main file

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Search multiple headings in other sheet, copy data and paste in main file

    I need a VBA code for a button which when clicked browse for other excel file, search for specific sheet named “Farmer History” in it. In this sheet it looks for A1 complete row and search heading “Crop Area” and copy this column data to main file(where button embedded) in sheet named “Berkhund” at address F3.
    The same to be done for other 2 columns too i.e
    Looks for “Target Qty” in first row at same sheet “Farmer History” and paste in main file sheet “Berkhund” at address R3
    Looks for “Commulative Sold” in first row at same sheet “Farmer History” and paste in main file sheet “Berkhund” at address S13
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Zahid0111; 03-12-2020 at 04:47 AM. Reason: Workbokks added

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Search multiple headings in other sheet, copy data and paste in main file

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Search multiple headings in other sheet, copy data and paste in main file

    @Pepe Le Mokko, i have added the workbooks..kindly help me

+ 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. Importing file as temp and copy paste info into main file!!! HELP PLEASE
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-05-2015, 02:01 PM
  2. VBA formula to copy paste selected data from main sheet to new sheet
    By vbanoob123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2014, 12:28 PM
  3. Copy/Paste filtered data from one sheet to another with only matched column headings
    By archerrc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2013, 05:00 PM
  4. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  5. Replies: 2
    Last Post: 02-06-2013, 11:25 AM
  6. [SOLVED] Macro to get/copy data from multiple secondary sheets to main sheet
    By CaatalyyN616 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2012, 04:22 AM

Tags for this Thread

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