in cel P2 on 5 sheets in a row there is a page of page numbers. eg 1 of 1 or 1 of 3 etc.
I want to do an if formula for each of the P2 cells....
sht1 P2= if sht2 C4="value" then "1 of 2" or if sht3 C4="value" then "1 of 3" etc etc
I think you get the idea. if sht3 C4 had a value but sht4 didnt then:
sht1 P2= "1 of 3"
sht2 P2= "2 of 3"
sht3 P2= "3 of 3"
Then once that is complete i would like to have a button with a macro to make a single PDF for with pages for sheets - sht1 & sht2 & sht3 with the PDF saved as the job name "sht1 C2" then a space and then the date in "sht1 J2"
Is this possible?? each of the sht's is the size of and A4 landscape.