Learn Excel - Video 238 - VBA -Macro to Transfer 100 sheets data in one Workbook

We are learning how to export or transfer or copy/paste data from multiple workbooks in one standard template. Learning how to run loops in loops. Extremely beneficial and advance vba code for you.

[SannareddyHarshavardhan]

Thanks You Ajay !!!

It would be much more helpful if you save all those files in a folder and then compile it to single file.

of-course, you have videos on file handling.

[rickyshukla]

Sir how can we open multiple workbooks at a time from folder in this tutorial

[krish]

Hi Ajay, Could you please help how to use (*) symbol in below formula. I tried lot of times, it getting error.

Range("d2").FormulaLocal = "=countif(" & Range("b2:b7").Address() & ", " & & ", " & Range("a2:a7").Address() & ", " & "*cms*" & ")"

In above formula, last criteria ("*cms*") here i'm getting error.