Log In
Register
Home
July 19, 2014
Offline
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
Offline
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
July 19, 2014
Offline
Hi Sunny,
I see that is very easy than using formulas, I'm looking the code to understated better.
But what about if the table has a blank raw? I want the MergeData to excluded blanks row.
Thx,
Dritan
VIP
Trusted Members
June 25, 2016
Offline
Hi Dritan
There doesn't seems to be blank rows in your attachment.
What do you considered to be blank?
I would merge all data first then will I delete the blank rows. It will be easier than to identify each and everyone from the sheets.
Sunny
July 19, 2014
Offline
Hi Sunny,
Well, I guess if I have a scenario of table who has blank rows among?
Thank you for your support
Dritan
VIP
Trusted Members
December 7, 2016
Offline
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)
