Help with VBA - insert / copy / paste button

Hi Gents

I have a button in the attached in the quote tab that inserts / copys / pastes row 6 in the row below.

when the button is used it pastes the cells in the wrong places and I can work out why.

Can someone point out where i am going wrong please.

thanks

nelly

You'd need to use absolute references in your formulae on row 6 - i.e.
='Quote Tool'!$H$6
instead of
='Quote Tool'!H6

Also, I may not be understanding what this does, but as it stands every line will be the same, which doesn't seem right.

Originally Posted by brokenbiscuits

You'd need to use absolute references in your formulae on row 6 - i.e.
='Quote Tool'!$H$6
instead of
='Quote Tool'!H6

Thank you, a simple thing but so important.

[/QUOTE]Also, I may not be understanding what this does, but as it stands every line will be the same, which doesn't seem right.[/QUOTE]

A very good point that I had not taken into account, I would like the information in row 6 to be frozen after the row has been copied, I have also just realized that the macro would need to copy the next row down each time rather than row 6 each time.

any help please as my VBA knowledge is still at the beginners stage

Thanks

nelly