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

Hi Julielara

This Code in the attached will work on your Sample Data (report dec) but there are many inconsistencies in the Data. It will probably need to be modified to accommodate any additional unknown inconsistencies.

CTRL + x will fire the Code.

Please Login or Register  to view this content.

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.