Another Excel Question
does anyone know if you can create several named ranges in excel, and then tell excel to print each names range in that order. for example:
Sheet 1 has the named ranges red, blue and green
sheet 2 has the named ranges red1, blue1 and green1
sheet 3 has the named ranges red2, blue2, and green2
i like to print the ranges red, red1, red2, blue, blue1, blue2, green, green1 and then green2 - i am actually trying to print this worksheet to a pdf file.
do to the layout of each worksheet, i cant move all the raanges to reside on one worksheet and then change the print order to across, then down.
i can manipulate the order of the worksehets in adobe - that that is a painful process......
i miss the simplcity of lotus 1-2-3........
|