Hello, i would like to know if there is a VB Code to take from sheet "store" some specific columns and cells an print them in one page.
In my test file i would like to print the Header A1:A2 and then the columns A:B,D:J
At the end of the page i want to print the cells L4:Q4.
Because it will have more than 100 entries, i would like the header A1:A2 to be printed to everypage at the top of it.
I supposed it can be done with a makro to copy all the cells-columns i need to print to another new sheet and after the print delete this new sheet, but i don't know how.
Any help with that?
Bookmarks