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
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.myonlinetraininghub.com/merge-excel-worksheets-with-vba
Sunny
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
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
Hi Sunny,
Well, I guess if I have a scenario of table who has blank rows among?
Thank you for your support
Dritan
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.myonlinetraininghub.com/power-query-get-files-from-a-folder
Another example. https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
Br,
Anders
Hi Anders,
Thank you for providing help, I'll see how it works because I'm not so familiarized with Power Query 🙁
Best Regards,
Dritan
