Ivan,

I tried this and get a runtime error!

Im not sure if its because the command lines get carrage returns on
here and I might not be putting them together correctly. I dont think I
explained myself properly anyway. I'll try again!

My workbook has 3 sheets labelled customer copy, financial copy and
temp parts.

Temp parts has 4 columns. The headers are Part description, Part
number, Trade price and list price.

Customer copy has a parts used section starting from A23 downwards, and
I only want the part description and quantity values displayed here as
this will be printed out on site and given to the customer.

Customer copy has a graphic icon to run a user form where the combo box
picks off the part descriptions and places them in the next available
empty cell when a button named add is pressed. As there will almost
certainly be more than one part used on each job, everytime the add
button is pressed it needs to select the next available cell in column
A from row 23 downwards.

The last sheet, finacial copy is exactly the same as customer copy, but
in the parts used section, I not only need column A from temp parts
placed from row 23 onwards, but also the data from column B, C & D as
well to tell us what that part costed us, what the customer has been
charged, and the part number.

I think that explains what i need a little better?

Dont work too hard at the weekend mate!

Cheers for now,

Kev