macro for paste special values in different location
 

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!

macro for paste special values in different location
 

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

Code:
--------------------

2. LastRow=activesheet.range("A65536").End(xlup).Row

--------------------


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=386373