Formula or Macro

[SF2014]

Hello,

My Excel sheet has two tabs:

• "Follow Ups" where I have multiple rows of data, and in column M there is a drop-down option where you can choose "open", "closed", "Critical", etc...
• "Critical Email" This tab is currently blank, but what I would like to do, is for every row in the "follow ups" tab that has "Critical" in column M, to bring that data over to the new tab (with the same headings from the "follow up" tab).

If it is best for this to be a macro - I'd love to be able to have it set up to also email the "Critical Email" tab to two specific email addresses.

Is this possible? Or what are my best options?

Thank you!

 

[dreid1011]

Formula option:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	FOLLOW UPS
2	AWB #	Orig	Dest	AWB Date	# of PCS	Product	Shipper	Notes					Follow up Status
3								1-Jul	Day 2	Day 3	Day 4	Day 5+
4	000-00000001	XXX	XXX	7/1/2024	0	XXX	SHIPPER NAME 1						Booked
5	000-00000002	XXX	XXX	7/2/2024	0	XXX	SHIPPER NAME 2						Open
6	000-00000003	XXX	XXX	7/3/2024	0	XXX	SHIPPER NAME 3						Critical
7	000-00000004	XXX	XXX	7/4/2024	0	XXX	SHIPPER NAME 4						MPR
8	000-00000005	XXX	XXX	7/5/2024	0	XXX	SHIPPER NAME 5						Missing
9	000-00000006	XXX	XXX	7/6/2024	0	XXX	SHIPPER NAME 6						Critical
10	000-00000007	XXX	XXX	7/7/2024	0	XXX	SHIPPER NAME 7						NCNS
11	000-00000008	XXX	XXX	7/8/2024	0	XXX	SHIPPER NAME 8						Contrained Lane
Follow Ups

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	AWB #	Orig	Dest	AWB Date	# of PCS	Product	Shipper	Notes					Follow up Status
3								1-Jul	Day 2	Day 3	Day 4	Day 5+
4	000-00000003	XXX	XXX	45476	0	XXX	SHIPPER NAME 3	0	0	0	0	0	Critical
5	000-00000006	XXX	XXX	45479	0	XXX	SHIPPER NAME 6	0	0	0	0	0	Critical
Critical Email

Cell Formulas
Range	Formula
A4:M5	A4	=FILTER('Follow Ups'!A4:M30,'Follow Ups'!M4:M30="Critical")
Dynamic array formulas.