Hi
I have data in excel in column A Days in B Column Date in C column C Units in D column Assignments i want Sum of units with assignment number If Weekday then update that in Sheet 2 Allowance Type Weekday & Element On call If weekend Then Allowance type Weekend & Element On call in Units column update the Sum.In column F:I Saturday,Sunday,Weekday,Bank Holiday below these headers any value update as .If Saturday & weekday any value that sum update in sheet2 in Allowance Type Emer 1.5 & Element Update as Emer.If Sunady or Bank Holiday Column any Value of sum Update as in Allowance Type Emer 2 & Element as Emer.Please help me and Give me macro for this
I have data in excel in column A Days in B Column Date in C column C Units in D column Assignments i want Sum of units with assignment number If Weekday then update that in Sheet 2 Allowance Type Weekday & Element On call If weekend Then Allowance type Weekend & Element On call in Units column update the Sum.In column F:I Saturday,Sunday,Weekday,Bank Holiday below these headers any value update as .If Saturday & weekday any value that sum update in sheet2 in Allowance Type Emer 1.5 & Element Update as Emer.If Sunady or Bank Holiday Column any Value of sum Update as in Allowance Type Emer 2 & Element as Emer.Please help me and Give me macro for this