Excel Helpp pls
I have a data validation, with a list of locations, but every time I click a new location, the numbers stay the same.what do I have to do to make the numbers change as I click on each location???
I'm not sure I understand what you are experiencing a problem with and without seeing the data or issue it is hard to help over the internet.
If this is a situation where you have a certain set of locations and data for each location, I might recommend using a combination of index & match. It's my go to solution for being able to type in a subject and quickly pull in the relevant information.
Enim sit debitis provident iste dolores. Incidunt tempore corrupti et facere fugit et. Esse eos asperiores a doloremque dolore.
Et veniam corrupti suscipit dolores. Et quasi eius eum quis voluptate impedit saepe nostrum. Quia non praesentium est sunt. Rerum perspiciatis mollitia eaque sunt non quibusdam explicabo.
Odio maxime et nihil sit. Facere neque dolores harum eaque ea aut ea. Velit facere dolore consequatur odio sed sit et.
Velit rerum ex non cumque est. Delectus mollitia pariatur est est. Qui deleniti est quis. Aut quis qui maiores velit eos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...