Thread: Excel File Connector

Hello, This is kam here, I am visiting excel forum for the first time.

I have huge excel database which has almost 27000 rows & around 26 columns (I have attached the sample file)

& after that around 15 small files & now I want to connect all this files to main database which has 27000 thousand rows, whenever I make any changes in main database it should automatically make changes in all 15 respective files.

It would be great if you just guide me for a start then I will take from there...

Please let me know if you need any further info from my side...

I have tried connecting all files to main database using vlookup but when I open all respective files it get hangs.

Appreciate your help on this topic.

Best Regards,
Kam.

Can anyone guide me Please...Please...