Hi all - looking for suggested ways I can update some data.
We have a UI where anyone can configure some search fields then run a macro which opens the "master" file on the server, filters the master based on search fields and then it returns the data back to the UI sheet.
- the data in filtered for on "master" is not in sequential row numbers
- when it is copied to the UI sheet it is pasted unfiltered.... so if 10 rows were copied it will paste from A12 to A22
we often then close the action, or update any of these cells. What is the best way to be able to then take those 10 rows and be able to update it back into the "master" file by 'over-writing' the rows the data originally were in?
We have a UI where anyone can configure some search fields then run a macro which opens the "master" file on the server, filters the master based on search fields and then it returns the data back to the UI sheet.
- the data in filtered for on "master" is not in sequential row numbers
- when it is copied to the UI sheet it is pasted unfiltered.... so if 10 rows were copied it will paste from A12 to A22
we often then close the action, or update any of these cells. What is the best way to be able to then take those 10 rows and be able to update it back into the "master" file by 'over-writing' the rows the data originally were in?