Hi everyone,

First off, thank you in advance to anyone that can assist me with this. I think this is fairly complicated, and that I need a VBA macro in order to achieve what I am looking for... but I have no idea how to write it.

I have one main document - a schedule - that I want to be completed with information from a number of other documents. All of these other documents have the same structure - basically a template is used that I created.

I want a script that will run and pull information from certain cells from each document within a set directory and populate set cells in the main schedule. Each document will have it's information inputted onto a separate row of this main schedule.

For instance - in the main Event Schedule doc - we have each column A4:I4, Date, Name, Time, etc.... These cells should be populated with the information from BEO-01. Then the script will open doc BEO-02 and populate the next row in the schedule - A5:I5 - and so on. The script should end when it has completed all of the BEO-## documents in the directory.

Is this even possible???



Thank you soooooooooooooooo very much for any information you can throw my way to make this happen.

p.s.: I hope this is possible