Macro for paste special of a number

F

fophis

Joined
Aug 14, 2007
Messages
3
Reaction score
0
I am not sure how to say this so here is what I need. the from is on sheet 1 and the paste special is on sheet 2
find last empy row in column A paste special date form A2
find last empy row in column B paste special Number form B13
find last empy row in column D paste special Number from B27
find last empy row in column E paste special Number form I15
find last empy row in column F paste special Number from I20
then clear B5:E11 so I can put info in for the next week
move the number in I5 to the last empy row in row I but no lower then I9
if there is numbers in I5:I8 clear I5:I9 this is because some months there will 5 instead of 4 so this will take care of both of those possibility.
 
Last edited:

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

Copy, paste first empty row 1
"Paste Special" does not work?? 1
Adding empty row with code 2
Need help with modify this macro to copy. 3
Paste in column B using Last row of either column B, C or D. 10
Copy columns and paste with blank column between 5
Find two values and select data in between 2
Append column for pasting 1

Top