Hi all, I’m wanting to populate a printable area with tables on a daily basis.


This changes from day to day. The tables are all 3 columns wide so I can fit two side by side, but they all have a varying number of rows.
Some days I may only need 2 tables, but sometimes it could be 6.
I currently have a printable area with all my tables next to it and I just highlight and drag each day as needed, but is there a way to automate this?
Thanks

Sure, but how much work do you want to go to? I like programming so I'm often willing to spend three days on a problem that'll save me ten minutes a day. But if you don't enjoy the work, you may decide it's better to just keep doing it manually.

And if you're still thinking about writing a VBA program to do it (and let me tell you that getting a program to work, and using it afterward, does wonders for your I'm-so-clever! feelings), the next question might be "How do you decide whether you need two tables or six?". Because you have to be able to say how you make that decision in order to tell a program how to make that decision.