Excel printing

  kimtrnc 05:04 22 May 09
Locked

I have been asked to help with a local charity library. There are approx 10,000 books, which need updating/removing regularly. Handling the data is not a problem - but how can I print alternate pages (approx 300) please? May also need to alternate margins, but I can manage that, I hope.....
TIA
Kim

  wiz-king 07:18 22 May 09

What version Of Excel are you using?

  kimtrnc 07:50 22 May 09

Wiz King - OFFICE 97. Thanks

  Picklefactory 08:02 22 May 09

Can you not do that via your printer software. I have HP at work and Epson at home, and on one I can select either odd or even page numbers to print, and on the other I can select to print both sides (Printer is NOT duplex), so it only prints odds and then requests the paper replacing other way up to print evens.
Is that an option at all?

  kimtrnc 09:28 22 May 09

Picklefactory, you got me all excited there! However, my laserjet 1000 does not support this function, and all HP can suggest is upgrading the printer to a newer model......what a surprise!
Thanks anyway

  Picklefactory 13:01 22 May 09

It can be done within Excel, but I think it would require some VBA. I'll see what I can find, but someone will probably be along before I get there, and with a better answer than I'll find anyway.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…