Please Register to Remove these Ads
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.