Hi All,

I'm pretty new to using Excel and VBA but have managed to create 2 workbooks with a userform attached to each. The workbooks are Quotes and Production List.

Both have identical columns and formatting etc so once a quote has been entered onto the Quote sheet and accepted I can copy that row of information and paste it into the Production list.
The Production list uses a Userform to produce a Job sheet. The Job sheet has 30 text boxes that are populated when the quote number is selected from a combobox.
Now this is where the problem happens.....
When i select the quote number of the copied data the userform crashes with an error message. Runtime error '1004': Unable to get the Vlookup property of the WorksheetFunction class.
If I enter the exact same data into the Production List manually the Userform is quite happy to display all the data. The crash only happens with the copy & pasted data.
The cell data is made up of stuff like customer information, phone numbers, job descriptions.

I hope you can suggest a solution as it's driving me insane.

Thanks in advance.