Hello and thank you in advance guys!
So I've got this problem, where I've got a table with information about projects.
Ive made a lookup function to bring information from the table to an other worksheet by giving it an application number of a project.
Now what I would like to do is to (maybe have an other row) where I can change the information given by the lookup function,
and maybe use a macro to replace the information in the table by the newly added numbers.
So for example, I give the lookup function the number 25, which brings me the budgets for the next 3 years and the people in charge of the projects.
I then would want to change, for example the budgets to match the valid data of today, and add them to the table for further usage.
Sorry if I'm not making any sense.
So I've got this problem, where I've got a table with information about projects.
Ive made a lookup function to bring information from the table to an other worksheet by giving it an application number of a project.
Now what I would like to do is to (maybe have an other row) where I can change the information given by the lookup function,
and maybe use a macro to replace the information in the table by the newly added numbers.
So for example, I give the lookup function the number 25, which brings me the budgets for the next 3 years and the people in charge of the projects.
I then would want to change, for example the budgets to match the valid data of today, and add them to the table for further usage.
Sorry if I'm not making any sense.