Hi all.
I have a worksheet named "Order Form" whereby it's already running on a script where upon clicking a button, it automatically uploads the information to another sheet (within the same document) "Data".
Thus, "Data" is always receiving new information.
As the "Data" will be outsourced to various departments to work on, I would like to add a checkbox to assign the department. Thereafter, reflecting selected information (from selected columns) onto a new google sheet for that department's easy viewing
Can someone please advise on a suitable macro/script?
Thank you!
I have a worksheet named "Order Form" whereby it's already running on a script where upon clicking a button, it automatically uploads the information to another sheet (within the same document) "Data".
Thus, "Data" is always receiving new information.
As the "Data" will be outsourced to various departments to work on, I would like to add a checkbox to assign the department. Thereafter, reflecting selected information (from selected columns) onto a new google sheet for that department's easy viewing
Can someone please advise on a suitable macro/script?
Thank you!
