Hi Everyone,
I have an index worksheet that shows a list of (50+) companies that are linked to their individual worksheets. On their individual worksheets, we have to show the date our salesmen talked/interacted with them, their business contact, number, topic discussed, and the follow up action to be performed (call them next week, monthly reminder to contact, etc.) I'd love if I could get the index sheet to show the follow up action & when it's due next to the company name but I'll be more than happy if I could just get it to show when a change was last made. I've tried a few different ways from online but no luck. Any ideas/suggestions would be greatly appreciated!
I have an index worksheet that shows a list of (50+) companies that are linked to their individual worksheets. On their individual worksheets, we have to show the date our salesmen talked/interacted with them, their business contact, number, topic discussed, and the follow up action to be performed (call them next week, monthly reminder to contact, etc.) I'd love if I could get the index sheet to show the follow up action & when it's due next to the company name but I'll be more than happy if I could just get it to show when a change was last made. I've tried a few different ways from online but no luck. Any ideas/suggestions would be greatly appreciated!