Hey all, first post and hope you can all help.
I have a list which a vlookup is running from in the background. It basically helps populate sales into Sales Teams (by Postal Sector) and thus populate regions with sales from the salesteams.
However we're thinking of moving some sales teams to other regions and we wanted to see what would happen to leads, sales and revenue as a result for the regions involved.
So I thought if I have a vlookup with the salesteam looking up the region I could then change the region in the lookup list and it would then change the data in the main block to 'move' the salesteam to another region. However sine the CEO and CFO will be using this sheet (and are not too confident with excel) I wanted to make it as easy as possible. I've got two drop down lists, one with sales team and the other with Region. I wanted to have them select the sales team they want to move from Drop Down1 and the Region they want to move it to in Drop Down2 and then to hit a 'Confirm Changes' button. I was then hoping that I could update the List with the Sales Team and Region associated with it, to reflect the changes - can this be done and how would it be performed. Been racking my brain for days now with no joy!
I can't seem to upload a pic which explains it really clearly. But have attached it in the hope it works and helps explain what I'm trying to achieve!
Any help appreciated!
Bookmarks