01-07-2020, 07:54 PM
|
 |
Expert
|
|
Join Date: May 2013
Location: USA
Posts: 700
|
|
It seems to me this has the same solution as a question I read recently. The difference is that he would have had to create only five extra columns and do a VLOOKUP in each one, whereas you have to do a SUM referring to 52 different arguments. Maybe someone could suggest how to get there by emulating a three-dimensional table, but I've never done that and wouldn't know how to make it work.
I would certainly do this in VBA—much simpler. But if you don't know how to program it, and wouldn't care to learn, I don't know how to help.
If you would care to learn, let me know and I'll coach you. But you would need more than a few days to do it, unless you already know some programming and just need a few hints. Well worth the trouble, I think, but it's your call.
|
Similar Threads
VBA: Selecting columns from multiple tables
Windows 7 64bit 
Office 2010 32bit
Threaded Mode