printing to order

[stevesunfold]

hi guys

heres a good one

i have a spreadsheet with 2 sheets and sheet 1 interlocks with sheet 2 meaning when i have all the data is entered on sheet 1 it goes to corresponding cells in sheet 2 then my work is done.

the question is when i have input my data the job is complete but i need 2 pages printed of each sheet i obviously do this manually printing 2 from sheet 1 and then 2 from sheet 2 i wondered if there was any piece of code that could do this for me so i just press something like ctrl + p the once and it does it for me?


help gratefully received

thanks gents

[EdMac]

Have you considered using the macro recorder?

[stevesunfold]

jeez

thanks mate somtimes things just pass me by
yes indeed that is what i shall do

thanks m8

[stevesunfold]

whilst i am here is there anyway that you can make sure that any data input is always in capitals?

thanks

[stevesunfold]

Must Be Impossible Im Guessing Guys

[EdMac]

You would need a macro - try searching the forum as the question has been asked before.