

July 19, 2014

Hi Sunny,
I have merge data of several sheets (Table 1; Table 2; Table 3) into a General Table of an Excel file.
The General Table is a dynamic.
But i face difficulty when I add more sheets, the calculations are becoming so slow.
Is there any other way through formulas, maybe other formulas combination?
I believe that you can provide me with a very clever way.
Best Regards,
Dritan

VIP

Trusted Members

June 25, 2016

Hi Ditran
In your situation I would normally use a macro to merge the data.
Using formulas is too complex.
You can look into this article to see if it helps : https://www.myonlinetraininghu.....s-with-vba
Sunny

VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

December 7, 2016

Hi Dritan,
Have you considered using Power Query? With PQ this is an easy task, do check it out.
One example of how you work with PQ. https://www.myonlinetraininghu.....m-a-folder
Another example. https://www.myonlinetraininghu.....ower-query
Br,
Anders
1 Guest(s)
