Hello,
I have a data table of large size in one sheet and i created a simple navigator to pull info from it on another sheet.
The user uses the navigator and may change some values in order to run some simulations. If the values he changed satisfy him, he should be able to save them in the original data table for future reference.
In the table i have a row key that identifies the rows where the value should be changed and the column, is constant.
I do not know how to create a macro that will search all the rows that match the key and change the values of a certain column. I could make a macro that filters the table to match the key and then changes the visible values but im sure there must be a better way.
Can anyone help me with this problem?
Bookmarks