Help crunching of lots of horizontal data? (budget tracking)

Hello! Hope someone can help me out with this...

In the attached document, the user completes columns A-E, and then a pop-up appears, asking them to tick boxes in various categories to divvy the total spend. The user ticks the boxes and closes the pop-up, and Excel automatically populates the hidden columns G-U.

Now, we have a load of horizontal data that we're having a difficult time making meaningful sense of. Example, we'd like to quickly be able to say we spent £X on hotels in all European countries for the Math and Science programmes... or £Y on hotels and travel for the Arts programme. Hope this example makes sense...

QUESTIONS:

1. Is there a way to answer the example questions I just posed? (In the current ACTUAL spreadsheet, it's probably 150-200 hidden columns across that we're trying to extract meaningful conclusions from...)

2. If this doesn't work the way it's currently set up... is there a way for someone to explain alternative options?

I know this is really messy, but fingers crossed someone can give some insight. Thank you VERY much!

In the attached document, the user completes columns A-E, and then a pop-up appears, asking them to tick boxes in various categories to divvy the total spend. The user ticks the boxes and closes the pop-up, and Excel automatically populates the hidden columns G-U.

Where can this be found?

You can better adjust the setup in tabular form than it is easy to use filters / pivot tables.

Thanks for your reply. The previously attached Excel document for this forum post only shows what the resulting data/spreadsheet would show... it is a tiny/clean sample I just typed in and doesn't include macros or pop-up windows... I was hoping to avoid recreating that aspect of things and I thought this would be simpler.

The original spreadsheet already has ten tabs - each using a different budget code. Ignoring that fact, though, and assuming we try to set something up in tabular form, are you suggesting something like the first tab is for user input and the pop-up window to collect the user tickbox entries... then that data populates one tab for each of the three categories in my example?

Hi there, and thanks again. My sincerest apologies, as I'm not a programmer by any stretch. This looks to copy data from one sheet into another maybe? I'm not sure I quite understand how this helps me (sorry again), but I have been mulling it over for quite some time now and will continue to do so! If you'd be so kind as to further explain how this helps I'd greatly appreciate it! I promise I'm trying to apply your code snippet to answering my questions, but it's definitely escaping me...

Thanks again!

Somehow this code got into the wrong thread. Sorry about this.

OK- no problem. Maybe I'll get lucky with someone else responding!