Hello,
I am Excel and VBA expert.
I can do this project (VBA macro) in Excel. I can not do it in PowerShell. If Excel is acceptable then let me know.
How many rows do the files have?
If you have any questions, I will be happy to answer.
Please note that I have 100% completion rate and 5-star feedback on over 50 projects.
Jan