macro for paste special values in different location

[Das S.K]

I have two sheet i.e sheet1 & sheet2 in a workbook. sheet 1 cotains data
hours worked by five persons named A,B,C,D,E against each day of month. Last
row is the summation of hours worked by each persons. Cell "D1" in sheet1
is drop down list for month.
I want macro which will paste special value of Last row of sheet1( the
summation of hours worked by each persons )to sheet2 against respective
month(as per selected month in Cell "D1" in sheet1).
Any assistance would be great!

[BrianB]

1. Can't you just use worksheet function SUMIF() ?

Please Login or Register  to view this content.