Hi! I just started with VBA since just recording macro functions are not helping me anymore :P
So, what I'm trying to do is to copy data from specific columns, that are in different order and in different worksheets, and produce a new sheet with the compiled information from all the worksheets.
I need this because I receive a large number of sheets from different employees, and the sheets they complete have different column headers (on purpose) and it's a pain to manually copy paste everything everyday
If you guys could be kind enought to add some coments on the code so I can better understand what I'm doing it would be very helpfull. That way I can have my problem solved and learn some VBA in the process ^^
I Attached my workbook.
Pasta1.xlsx
Hope you guys can help -- I'm losing my hope
Bookmarks