stoneham96
New Member
- Joined
- Apr 28, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm brand new to writing VBA code so need all the help I can get.
I have got 'N' number of files located within a folder (for sake of argument use C:\Users\wthomas\Desktop\Data), with the files I need all following the same naming convention "MAL1234567 Data.csv". This folder will continuously be being refreshed with more data (so MAL1234568, MAL1234569 etc.).
I need to copy the data from cells H2:N2 within each of these files and paste it into another workbook. When I paste it, I need it to populate the next free line available within columns B:H, and for it to not paste the data if a duplicate value is seen in column B.
Please let me know if you need any more information.
Thank you in advance for any help you can give me , I really appreciate it
I'm brand new to writing VBA code so need all the help I can get.
I have got 'N' number of files located within a folder (for sake of argument use C:\Users\wthomas\Desktop\Data), with the files I need all following the same naming convention "MAL1234567 Data.csv". This folder will continuously be being refreshed with more data (so MAL1234568, MAL1234569 etc.).
I need to copy the data from cells H2:N2 within each of these files and paste it into another workbook. When I paste it, I need it to populate the next free line available within columns B:H, and for it to not paste the data if a duplicate value is seen in column B.
Please let me know if you need any more information.
Thank you in advance for any help you can give me , I really appreciate it