macro code for summing of leave for employees

[skml]

Dear Sir,

I have attached workbook named Leave.xlsx. The workbook contains two worksheets named Rawdata and Output.

Kindly provide me a macro code to fetch data from worksheet named Rawdata and display the data in the worksheet named output.

The worksheet named Rawdata contains two employees which they have availed leave in different dates

The leave availed should be summed and display it in the worksheet named output for the two employees.

I have workbook for your reference.

I don't want to do it in pivot table.

Regards

[JohnTopley]

In Output

in A2

=IFERROR(INDEX(RAWDATA!$A$2:$A$10, MATCH(0, INDEX(COUNTIF($A$1:$A1, RAWDATA!$A$2:$A$10), 0, 0), 0)), "")

in B2

=VLOOKUP($A2,RAWDATA!$A$2:$F$2,COLUMN(B$1),0)

Copy across

in G2

=SUMIF(RAWDATA!$A$2:$A$6,OUTPUT!$A2,RAWDATA!$G$2:$G$6)

[nankw83]

Hi skml,

Try below code ...

Please Login or Register  to view this content.

[skml]

Dear Mr Nank83

Tested. Working fine.

Thanks for your response.

Regards