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.
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.