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.
|