Forum

Hello Elinor, If you want to improve the document you should go with the solution that Mynda suggested, it will among other benefits make it easier...

Hi Terri, This sounds to me like interactive tooltips, partly anyway. I am pretty sure you can build this with VBA, but you can of course build som...

Hello, Go to Data tab and click Queries & Connections, from this view you can remove the queries. Br, Anders

Hi, I would say that if you clean up the data in RECOMMENDATION column in Expired Policies sheet so that you have a fixed number of different recom...

Hi Vivek, This is a topic I am not that familiar with, I simply avoid to reference to other files unless working with Power Query. I found this art...

Hi, As usual with Excel, there is more than one way you can do it to get what you want. The result is the same as what Sunny already gave you, just...

Hi Tarun, Please provide a sample file plus more details of what you are trying to achieve. Br, Anders

Hi Juliana, Do check these blog posts, I am pretty sure they will give you the guidance needed. https://www.myonlinetraininghub.com/calculating-t...

Hi Paul, Glad you found the solutions useful. Even though we use functions that are volatile they are useful and don't make any fuzz in a file with...

Hi Paul, Not sure why you use the INDEX function, I don't see any need of it as one and each of the site names are unique. Anyway, I simplified you...

Hi Dritan, Have you considered using Power Query? With PQ this is an easy task, do check it out. One example of how you work with PQ.Another exa...

Hi Pam, Do check out this blog from Philip, it contains lots of useful stuff. What you can do is to use =GET.CELL function in a defined name to e...

Hello Teddy, One simple trick is to add a new column in your source data, name it like ID or something like that, and then add for example numbers ...

Hello Dritan, Personnally I would do as Frans suggests, giving each person a copy of the file containing only their sheet. I would then use Power Q...

Hi, Great that you found out the reason of the error. It is almost always those little things you don't think of that are the culprits. /Anders