Transfer specific row data to another sheet when a checkbox or drop down menu item chosen.

gwilkinson

In short, I would like to have a menu item or checkbox in one form that when checked it sends certain specific cells on said sheet to another sheet.

Can I tackle this with an automation?

Matt Lynn ACT

@gwilkinson You can copy/move an entire row. If you're only wanting some info from that row on another sheet, you'd have to put a formula on that destination sheet to look for said value, if the checkbox at that row was checked. Something like a index(collect()). Not sure that's what you're looking for though?