Hi, I have 0 experience in VBA but I managed to write one that allows me to do the ff:
1. Browse and select and open files
2. Delete a specific column if it exists and copy the remaining column starting Row 5 and paste the result in a specific sheet
Now I need to revise it but I can't seem to find any similar issue on and off this forum:
1. There are 13 source data and most of them have different Headers in the destination tab
2. Out of the 24-30 columns, I only need to copy 7 specific columns
2. The first 5 Columns may be copied as A: E but for the 6th-7th Column it should be based on the header of the source
Source Data: If cell H5 is equal to "Nationalité" or I5 is equal to Nationality or K5 is equal to Nazionalità
Copy H6 or I6 or K6 up to the last row with data to Colum F of the destination Data
Source Data: If cell X5 is equal to "Edad" or Y5 is equal to âge or AA5 is equal to età
Copy X6 or Y6 or AA6 up to the last row with data to Colum G of the destination Data
1. Browse and select and open files
2. Delete a specific column if it exists and copy the remaining column starting Row 5 and paste the result in a specific sheet
Now I need to revise it but I can't seem to find any similar issue on and off this forum:
1. There are 13 source data and most of them have different Headers in the destination tab
2. Out of the 24-30 columns, I only need to copy 7 specific columns
2. The first 5 Columns may be copied as A: E but for the 6th-7th Column it should be based on the header of the source
Source Data: If cell H5 is equal to "Nationalité" or I5 is equal to Nationality or K5 is equal to Nazionalità
Copy H6 or I6 or K6 up to the last row with data to Colum F of the destination Data
Source Data: If cell X5 is equal to "Edad" or Y5 is equal to âge or AA5 is equal to età
Copy X6 or Y6 or AA6 up to the last row with data to Colum G of the destination Data
