Sir,I need Vlookup Macro code.Conditions:-I have one Master Excel spreadsheet with only one Tab.And I have divided into 10 Separate Excel files

[Harshavardhan Kulkarni]

Sir,
I need Vlookup Macro code.

Conditions:-

I have one Master Excel spreadsheet with only one Tab.

And I have divided into 10 Separate Excel files spreadsheet each with respect to individual name. All the 10 separate Excel files has only one Tab each only.

For example in Master Excel spreadsheet Column A has unique values around 500.
Column B to column G Data is same in both Master Spreadsheet and 10 separate Excel files spreadsheet.

Column H we consider for Name.

But from Column H to Z I need to take Data from 10 Separate Each Excel Files spreadsheet Data into Master Excel spreadsheet with the help of Vlookup.

Manual If error Vlookup I have used but MS Excel Master Spreadsheet will hang due to huge Vlookup formula.

But I need Vlookup Macro code to run on a daily basis.

Rough Data you may create on your own basis to write Vlookup macro code.

Kindly help me out by providing Macro code and I tried from Google website but unable to match criteria.

Many thanks in advance for your help.

Harsha.

 

[Logit]

Two things ... please remove your phone number from your post. Also do not provide your personal email address. Think of safety for yourself and family members.

Second ... if you can post a copy of your workbooks ... with just a small sample of data in each. DO NOT include and private information in the data. That will be the best way
to move forward with assistance.

Thanks.