• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to search worksheet name from all files in folder & return data in master file

ALAMZEB

Member
I have five different files in one folder with quite few tabs in each of them. how ever
tabs names are similar. Each tab name is name of product and each file is for each state
Can i have the macro that first search tab name (from drop down in master file) in all five files and than pull data of specific range (lets say from A2 to H2) to each table in master file. tab name should be drop down
I am not good in macros and have to spend hours to extract info. if someone can help me that would be great and deeply appreciated
I am posting new thread because i believe i wasnt clea r my last post.
 

Attachments

  • Master File.xlsx
    11.6 KB · Views: 0
Back
Top