VBA Copy Multiple Column from Multiple Workbooks

[@alexrosen8762]

Scenarios like this is really practical and useful. Thanks a lot 🙏

[@z.719]

Great tutorial. Thanks for sharing!

[@arthurcv15]

Thank you so much, Sir! 😁

[@rushibhuva130]

This video is very useful. I am seeking for one tip, I am looking to perform a task in which I have to fetch 5 columns out of 20 columns by matching only column header.? As I just have to overnight in my final excel workbook when I copy, how can I do that without reference column.?

[@ridingnorthernlights]

I really loved how you walked through this scenario (subscribed)- excellent instruction and pace! How would you handle this scenario: (1) for (workbook) file-1 in a user-specified folder, open 1st file, copy column A values (values in row K1-K20 for every file) (2) In summary workbook, paste values in col G of workbook-Summary (3) next file-2 in the folder, open, copy column A (4) In summary workbook, paste values in col G+1 column of workbook-Summary.... etc... Generally speaking: For file 1 to n in the folder, open the workbook(sheet1)in folder , copy column A then in another summary workbook (), paste values in col G+n where n= 1,2,3,etc) column of workbook-Summary What I am curious about is not specifying which file; the macro runs until all files in the folder are processed (all column As are copied in the summary workbook in col G, G+1,... G+n...

[@MohAboAbdo]

Thank you very much, Sir.