Data from Master File

[ayyappan80]

Hi

Seeking help for creating VBA code for the below

See my example file, which is saved in path C:\sample\Master Data\Master Data Jun'20

I need to retrieve as results of Column L, M,O and Q from my master data.

Step1

In current workbook, any worksheet from B6 user type the Column A of my master data
and from C6 user type the column of B my master data

Step2
If column B6 and C6 matches with column A & B of my master data, then from D6,E6,F6 and G6 i need the results of column L, M and Q of my master data.

The Master data file should be considered as last modified file in the above folder. Since the master data will change frequently.
B5 to G5 header required from Master data.


We can do this from Vlookup but i need this master data frequently hence seeking help for VBA code.

[davesexcel]

Isn't column B unique values?

[ayyappan80]

Hi Davesexcel

Thanks. Column b in master data is not unique value

[jindon]

This should work (tested)

Please Login or Register  to view this content.

[ayyappan80]

thanks Jindon.

Its working as expected