
Announcements
I have an Excel Sheet with 20+ Columns and 50+=Rows. One Column is titled status. Where the Cell entry is Open in the status column, I want to send an email with all the rows that have a status of Open. I don't want to email all the Columns maybe 5 or 6.
I have tried many different methods but either just get the first row with a status of Open or a separate email for each Status open row.
Alternatively, if anyone can advise how I can move all Rows with a Status Cell Value = Open to a different worksheet that would be a help.
Thanks
Pat
Hello,
could you please let me know where is this excel stored?
Thanks.