Script for finding data on another tab and then changing it

Hi,

I have a tab with a FILTER formula on it that filters relevant order information from another tab in the same spreadsheet. I need to ad buttons on every row so that when the user clicks on it, it goes to the source data and changes the cell in the corresponding row from "open" to "CLOSED MANUALLY". My macro is not working though, can someone please have a look at my script to see what I'm doing wrong?

function Try() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getCurrentCell().offset(0, -3).activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Form responses'), true);
spreadsheet.getCurrentCell().setValue('CLOSED MANUALLY');
spreadsheet.getCurrentCell().offset(1, 0).activate();
var previousSheetIndex = spreadsheet.getActiveSheet().getIndex() - 1;
if (previousSheetIndex <= 0) { previousSheetIndex = spreadsheet.getSheets().length; }
spreadsheet.setActiveSheet(spreadsheet.getSheets()[previousSheetIndex - 1], true);
};

I tried to copy the order number in the macro as it's unique, and then search for it on the other sheet with find and replace but it doesn't work...

Thanks a million

Hi,

Thank you, I have attached it to this reply to your response. My need is to have a list of open orders on the open orders tab that gets automatically extracted from the rest of the data in the Form responses tab as per attached. The user needs to change the status of the order on the source (Form responses) tab from open to closed though and it takes them too much time to find it. So I need to ad something like a button with a macro next to each row in the Open orders tab so that it will automate that exercise for them. So if they click on the button in open orders then it needs to change the order on the Form responses sheet to closed. I don't mind if you change my filtering formula on the open orders sheet as I see it's full of errors at the moment but that's not my main concern at all.

Please let me know if you need more information.

Thanks again

Unfortunately the Form responses sheet ads a new row for every data entry. So I can edit existing data in it, but I can't set up a formula or rule that will apply for new orders as they come in because the new row will be exempt from all existing formulas etc. (and formatting)