Hello. Hoping someone can help me with this. This is my first post, so apologies in advance if this isn't posted to the correct place or if similar problems have been answered before.
Attached (I hope!!) is a dummy file with fake data, but replicates the issue I'm coming across. The actual file is a shared doc with the rest of the company and nearly everyone edits it on a daily basis.
DETAILS:
The Summary tab has dates in Row1 and PartnerNames in ColumnA. Row1 and ColumnA are hard entered.
The $$ values (revenue) in the remaining cells are sums of the revenue by partnername from BrandA, BrandB, BrandC tabs.
If you go to the tab for the Brand tabs, BrandA let's say, Row1 and ColumnA are set up the same way as the Summary tab. But instead of being hard entered strings, they are linked to the Summary tab and pull off of that.
The revenue, however, is hard entered.
Every morning, someone who works on BrandA would go into the BrandA tab and hard enter the revenue numbers from the prior day for a given partner.
All of these values get summed on the Summary tab, by date and by partner.
The issue i'm coming across is that everyone wants to have all the tabs alphabetized since it makes it easier each day to find the partner and enter the revenue (the real file has hundreds of partners). However, as time goes on, we get new partners. So someone will go to the Summary tab and add the new partner to the bottom of columnA. The Brand tabs will automatically pick up the new partner since it's linked to that cell in the Summary tab. And the Summary tab will pick up the total revenue since it's linked to the Brand tabs.
At first it seems like I can just alphabetize columnA on the Summary tab. And since the other tabs are linked to it, they all get alphabetized too. But the problem arises when the Brand tabs get alphabetized, but the revenue numbers don't shift along with it. For example, if a user alphabetizes columnA on the Summary tab, then the revenue which is applied to JKL on the brand tabs would now be applied to MNO after alphabetization.
My question is: How do I get the revenue numbers to move on the Brand tabs after the Summary tab's been alphabetized? I hate to say it, but this needs to be done without macros.
Any insights/feedback would be super helpful. Thanks in advance. I used the "manage attachments" feature to attach the file so I'm hoping it works after I submit this post.
Bookmarks