exel 2007

=IF(INDEX(EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y",IF(SUM(Y2:AD2)>=SUM(S2:X2),0,IF(SUM(S2:X2)>15000,15000*12%,SUM(S2:X2)*12%)),0). This formula is intended to work as follows. IF SUM(S2:X2) - SUM(Y2:AD2) >= SUM(S2:X2) * 12% THEN RESULT ELSE 0 Also H2,EmployeeMaster!A:A,0))="Y"...

I'm eceiving an Invalid Qualifier Error for LastPartNo in Sub InputPart, even though I have clearly defined it as an Integer before I tried to use it. I attempted dding a Temp Str type as a go between in case of a type mismatch. Still no luck. Ay help would be much apreciated! :) lSub...

Hi, I am looking for some help creating a VBA that will help me. I have two worksheets, contractor & list. Assume that Column (A) on the "contractor" worksheet is a named range from Column (A) on the "list" worksheet. On the "contractor" worksheet I would like to put in the contractors name...

Hi-- I have multiple school groups for one school name/contact -- how do I get them to merge into one doc. for each contact? The wizard just picks up each row and it creates a new doc. for each line... so a contact with 15 schools gets 15 docs.... this is what my excel doc looks like. <table...

Hi.. I've an Excel 2007 worksheet with a personalized ribbon and some macros. Depending of the selected sheet, I enable (or not) the ribbon buttons depending of the shown information on the sheet. My macros sometime crashes and excel starts the vba debugger. After that, my ribbon boutons are...