IF Statement with Macro

[Cooljazz]

hi Guys

I need your help to create macro for my work place. Work sheet tab call SAMPLE layout will remain same and thats the data i will be working on.

what I want

In next empty column it display comments and use two if statements as below

=IF(L2="BI",IF(M2="AL","Onsite allocated to auction",IF(M2="RL","Onsite released for auction",IF(M2="NR","Onsite NOT released for auction",IF(M2="UN","Onsite unsold",0)))))

and second one for RECENTLY SOLD =IF(OR(L33="ex",L33="sy"),IF(M33="SO",IF((I33>"10/08/2011"+0)*(I33<TODAY()),"Recently Sold",0)))

I want to combine them both statements (but not sure how i can do that) and get the results, if answer comes FALSE then leave that cell blank.

once that finish, in next column i want period or year to be displayed on the top and get year or period from column B as a result.

Third step, In next column empty i want to do the VLOOKUP to get the teams name

I want them to work till last empty cell.

Once all above is finish, i want to create pivot table. i have attached sample sheet with all the formulas and everything

Please help me to sort this out

thanks in advance

Jas