I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added.
The other possibility, would be to create a form for the log that would copy some information over to a single row on my master data sheet. I'm still playing around with ideas, so any insight would be helpful. I think the biggest challenge is that some data needs to exist in a single row and the other data needs to be broken up into multiple rows.
Please let me know if you need more information.