Good Afternoon,

I am looking for a bit of assistance.

We have a parts order form that we use to keep a record of parts ordered on a job.

We also have a delivery note, which said parts are then typed out again.

All the parts order excel files are saved within a separate job file for each job, which is ever increasing daily.

What I have though about it having a macro/vba etc within a delivery note template, which I can then open a file within this and it auto populate the fields with part description, quantity etc etc.

Is this possible? If so can you please point me in the right direction.

Thanks!

Daniel