Print Run and sheet update

[Endorphin]

Good morning all,

All help appreciated, well to be honest, anything would be good at this point..

I am trying to get the information (Company Name and Price increase) on to the printable sheet on the left and then complete a print run of all companys.
Also need to be able to select a company from a drop down list in the company name box to just print that single company record.
Sorry Brain not switched o this morning, Have sorted the problem with HLOOKUP but this is run from a drop down list but is there a way to get a macro to select each one in turn and then print that page.

Again, any help much appreciated..

Neil

[VBA Noob]

Maybe

Code in Module 1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Code in sheet called Print Sheet

Please Login or Register  to view this content.

The event macro changes the text of the button

VBA Noob

[Endorphin]

Many thanks, will give it a go.