dear rizvisa1, thanks for your speedy reply. I GOT THE SOLUTION FOR THIS.
You have mentioned that by "macro" we might get it done..so I tried "macro recording" to get it done. I would like to share that with you so that our friends can be benefited out of it
Procedure I have followed is as follows:
1) Turn on the Macro recorder
2) Copy the columns you want in the order you want to a second sheet until they are correctly displayed
3) Print the new sheet
4) Clear the copied data and return to the original sheet
5) Turn off the macro recorder.
Now, you have a macro that does what you want, reuse as needed.
thanks for your cooperation and help