Excel

[Robniq]

I am totally clueless about vb macros in excel, but i know that this can be done. I want to print multiple copies of a sheet with different values on each sheet that are calculated before each sheet being printed. I am tired of using print, calculate, print, calculate, print........etc, etc.

Basically, I am trying to print bingo cards with one card per sheet, with each card different.

[633Squadron]

Try this... ( replace words for numbers? )
https://yacostasolutions.com/make-bingo-game-in-ex...



Or if it is just a simple macro.

Show the Developer tab
On the File tab, go to Options > Customize Ribbon.
Under Customize the Ribbon and under Main Tabs, select the Developer check box


Record a macro. ( It memorises your keystrokes - and generates the VB code )

Copy and past that code for as many times as you need to print a bingo card on a sheet.


Or if you are not sure about editing the macro....
Just record the entire activity of generate- print. generate- print. generate- print.


The just run the macro when needed.

Edited by 633Squadron on Wednesday 4th August 06:35

[Robniq]

Thanks, recorded the macro as per your instructions. IT WORKS!!!

Thank you so much