I have a page called "ENTRY", this is where everyone puts the information in the database page called "db".
Occasionally they need to review an entry and possibly delete that transactions information. So they go to a page called "EDIT" and put in a transaction number in cell "M4".
This returns everything from the "db" page so they can read it.
If in fact they want to clear that entry, I need them to be able to press delete, and have it use that "id" and clear the contents from "B:DB". Not actually delete the row.
The id does not match the row number, and I need it to also enter the words "DELETED" in the first column of information "B".
Man I hope that makes sense.
EXAMPLE: Transaction 99 is entered on the edit page. It returns everything from that transaction, technically on row 156. So they press clear and now transaction id 99 now shows "DELETED" in the "B" column, and everything else from "C:DB" is cleared out.
Thank you in advance.
Occasionally they need to review an entry and possibly delete that transactions information. So they go to a page called "EDIT" and put in a transaction number in cell "M4".
This returns everything from the "db" page so they can read it.
If in fact they want to clear that entry, I need them to be able to press delete, and have it use that "id" and clear the contents from "B:DB". Not actually delete the row.
The id does not match the row number, and I need it to also enter the words "DELETED" in the first column of information "B".
Man I hope that makes sense.
EXAMPLE: Transaction 99 is entered on the edit page. It returns everything from that transaction, technically on row 156. So they press clear and now transaction id 99 now shows "DELETED" in the "B" column, and everything else from "C:DB" is cleared out.
Thank you in advance.