Thanks folks
I am going to consider my approach over the weekend.
I made some progress today with the team who are delivering the file. Turns out they do some manual manipulation before it is delivered to us so I am pushing back my ask on them to see if I can get the file nice and clean...
Hi All
I have tried to piece together a solution from numerous threads but have not solved my problem.
I am trying to upload an excel range (non adjacent columns and unkown amount of rows) to an array. Up to now I have used the below which uploads the full sheet and I have manipulated the...