Can cell data create a row?
Let's see if I can properly explain my question!
I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. I would like to use a modified version of the Agenda Item Follow Up template to turn any of those agenda items (from Meeting sheet) into task items for follow up...without copy and pasting into a new row on the Follow Up sheet.
So I'm wondering if it's possible to link an entire column to a new sheet? Or conditional formatting? Create a macro? That would streamline this process.
Thanks in advance!