VBA to extract data from Datasource to Master

[FGaxha]

Hi, Masters,

I have a workbook called "Master"
Column A to M
A= Code, B to M Jan, Feb,Mar, Apr to Dec.
I need to extract data from Workbook called "Datasource" to Master based on Code in Column A.
Datasource workbook contain 35000 rows, A= Code, column B to M Jan feb, to Dec.

Code on both workbooks are number's (7digits)

 

[alansidman]

Load each table to Power Query Editor. Perform a Join (Merge in PQ language) based upon common "Code."

 

[FGaxha]

Im looking for a macro vba to lookup “”Master” column A, from workbook “Datasource” column A,.
Master A1:M100
Datasource A1:M35000

Column A contains numeric value 7digits on both workbooks.
Thank you!

 

[alansidman]

VBA is specific to your data. Suggest you load some sample data using XL2BB. No pictures as it cannot be manipulated.

 

[FGaxha]

Master (contains 10 rows)
A1 b c d e f g h i j k l M

1
2
3

Datasource (contains 35000 rows)
A1 b c d e f g h i j k l M
1
2
3
4
5
6

I beed sumifs from Datasource to Master workbook.

 

[alansidman]

I don't understand your presentation. Please provide date in XL2BB format and show us a mocked up solution. Please then explain in detail what is happening in your sample data as it is not obvious to me.

 

[FGaxha]

I do not know how to do xl2bb

 

[alansidman]

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com