Hi all,
I have a table (G14:I60), I want to filter to find all cells in I60 with text, then copy the filtered table (G:I) to the bottom of another sheet (IE take all actions from today's meeting agenda with some topics having no actions, and make a summary list of only actions). There are also values below row 60 which I want to ignore for the whole process (i.e. not filter, not copy).
What I have is the below - The only step I can't get is copying 3 columns (G,H,I) not just Column I.
I had it working by filtering range G14:I60, but some notes in G were "No action needed", so I want to filter only by I (Due date) as these are true actions.
Any help?
Thanks
Bookmarks