| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy & paste-special-values data to selected worksheets | Excel Discussion (Misc queries) | |||
| Copy range in macro using paste special values | Excel Discussion (Misc queries) | |||
| copy, find next blank row, paste special location | Excel Programming | |||
| Cut and Paste using Macro gives paste special method error | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
