Create an excel vb macro

Hello,

I require a freelancer to create a vb macro to do the following (also please see attachment for details):

If value of Column ‘AP’ = ‘Y’ Then check value for column ‘AS’
{
If value of column ‘AS’ = ‘Closed’ or ‘Cancelled’ then check value of column ‘AE’
{
If value of column ‘AE’ = 0 then check column ‘M’
{
If value of column ‘M’ = ‘No Gap’ then do nothing
Else if value of column ‘M’ = ‘Gap’ then update ‘M’ = 'No Gap'
}
Else If value of column ‘AE’ = 100 then update ‘AE’ value to ‘0’ and update ‘AF’ to ‘current date’ and then check value of column ‘M’
{
If value of column ‘M’ = ‘No Gap’ then do nothing
Else if value of column ‘M’ = ‘Gap’ then update ‘M’ = 'No Gap'
}
}
Else If value of Column ‘AP’ = ‘Blank’ Then check value for column ‘AR’
{
If value of column ‘AR’ = ‘Blank’ Then
{
For all same values of column ‘AL’ (if AL is a numeric value)s
{
If all values of column ‘AE’ = ‘0’ then update ‘AR’ = ‘Close’
Else if all values of column ‘AE’ = ‘100’ then update ‘AR” = ‘Open’
Else if values of column contain ‘AE’ = ‘100’ and ‘AE’ = ‘0’ then update value of column ‘AR’ = 'Partially Remediated'
}
Update ‘AF’ to current date on all above updates made
}
}

Will share more details with freelancers that are selected.