Jason C. (job poster) hired Daniel F. (Tasker) to help with this task. Got a similar task you need done?

VBA macro to copy from multiple workbooks

Posted by Jason C.



Due date
Saturday, 16th Dec 2017

I need a macro to copy a column of data with drop downs into a "GPI MASTER" file, which will be paste as values and transpose to a row.

This task needs to be looped to complete all "GPI" files from 5 folders. So I should be able to just change file path in code where macro is copying from. I do no want to open all files, which are ".xlsx", to copy to master.

It does not matter if the data is duplicated in master.

Your help is appreciated! Many Thanks, Jason.
Jason C. left a review for Daniel F.
“Fantastic work by Daniel. Called to ensure every minute detail was discussed to ensure macro worked perfectly the first time and to expectation. Highly recommend! Will refer for friends/colleagues.”
Daniel F. left a review for Jason C.
“Clear and easy to communicate with. Would definately work with again :)”
Daniel F.
No Completion rate

The percentage of accepted tasks this Tasker has completed.

Sounds like a simple enough task and could have a look at it this afternoon. If you accept my offer we can have a chat on the phone to make sure it is not more complex than it sounds.
10 months ago
0 new tasks