bloomington
12-16-2014, 09:50 PM
Hi I have one small issue Im having trouble resolving. Simple one for those who know Im sure.
I have the following code....
Sheets("Sheet1").Select
Range("E3").Copy
Sheets("Sheet2").Select
Range("B2").PasteSpecial
Sheets("Sheet1").Select
Range("E4").Copy
Sheets("Sheet2").Select
Range("c2").PasteSpecial
What I would like to happen is each time I run the macro I want the values from E3 and E4 from Sheet 1 copied and pasted to Sheet 2 B2 and C2 respectively to start and then down one row after that each time. So the location of the source cells never changes, but the rows of the destination cells drops down each time the macro is run (so as to not overwrite previously pasted data).
Thanks
I have the following code....
Sheets("Sheet1").Select
Range("E3").Copy
Sheets("Sheet2").Select
Range("B2").PasteSpecial
Sheets("Sheet1").Select
Range("E4").Copy
Sheets("Sheet2").Select
Range("c2").PasteSpecial
What I would like to happen is each time I run the macro I want the values from E3 and E4 from Sheet 1 copied and pasted to Sheet 2 B2 and C2 respectively to start and then down one row after that each time. So the location of the source cells never changes, but the rows of the destination cells drops down each time the macro is run (so as to not overwrite previously pasted data).
Thanks