Amending code based on cell value

**mudraker** · 06-27-2009, 08:42 AM

I was not sure what you meant by working sheet so I have assumed it is the sheet name

Sheets("Completion sheet").PrintOut Copies:=Sheets("working sheet").Range("h12").Value

If it is the Active sheet then change

Sheets("working sheet")

to

Activesheet

**excellentexcel** · 06-27-2009, 08:47 AM

hi mudraker

working sheet is the sheet all the data is put into
ie name
address
etc etc

and then i have a sheet called completion sheet which would need to print the number of copies based on cell h12 in working sheet
i thnk that will be your top answer

thanks

**excellentexcel** · 06-27-2009, 09:09 AM

hi mudraker
its not doing as id hoped
i have attached it

so if cell h12 ( in yellow) has 3 in it i need it to print 3 copies of completionsheet and if it says 20 it needs to print 20

thanks for your help