Need vba to solve select criteria get SR no after # from desc and end with result if blank

Dear experts

I have month end data which contains multiple columns range A:G

Criteria is: in B:B column value apart from CSV File & Process by others select rest of all then column E:E select only blanks & N/A# then in column D:D see some description part exist with long string which some values comes with number sign # after # there is digits values is SR NO should be retrieve from description and fill the constrain rows which are not found SR no in description for blank cells of E:E column ,fill result like "SR No Not found"

Easy understand:
B:B select all apart from CSV File & Process by others then
E:E column select only Blank and n/A then
D:D in description part contains # after some digits values is SR No copy to E:E on consistent rows
G:G what are rows still blank in B:B towards G:G fill the text "SR No Not found"

find the attachment