macro for paste special values in different location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop to copy paste 5
Paste Special Macro 4
Macro to match 2 column values in different sheets 1
Automated Copy Paste 1
help with syntax for copy and pasting rows across sheets 4
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Run two macros for two different sheets 11
Copy and past using a lookup 1

Back
Top