Hi,

I'm trying to create a userform for the purpose of providing both quotes to my customers as well as giving me a break-down of
my own costs for doing each job.

On my directory, I have a folder for each customer containing both a workbook that holds the userform and also a separate order form that
the customer has submitted that contains details of the job they want done.

I'd like to be able to automate the process of extracting the information from the order form and pasting it into specific cells in the workbook
Ideally, the necessary code would be able to accomplish this without me having to manually specify the order form location(i.e. it would automatically
look for the order form in the same folder as the active workbook).

Any feedback on this would be greatly appreciated.

Regards

Anthony