Hi, Not sure if this is the right part of the forum to ask this, but hopefully someone can help me out!
Basically at my work we run a lot of listings adverts for events we put on. The cost of each advert and it's design is split between the different events included, based on how large they are.
We then have to create a summary for each Event which lists just their split of the adverts. So far I have just transferred this data from the main master budget to a separate sheet.
I'm wondering if there's a way for this to be done automatically? I've attached a sample file with a small mock-up of what would be the master budget and one of the summary sheets. (The real budget would have 40-50 different events, each event being included in 30 or so different ads etc).
Is there a way to do this or something similar?
Thanks in advance!Marketing budget example.xlsx
Bookmarks