Youseepooo
New Member
- Joined
- Feb 5, 2019
- Messages
- 37
Hello Fam,
I have a code that i want to adjust. It currently goes to the bottom of the specific "1360 $ " Sheet and copies last range in column A, i want to select and copy the last ranges in the column then paste it in the Summary Sheet.
It currently only posts the last cell in "1360$" is there a coded like someone can help me with to get it to instead copy last cell in Column A, COPY LAST 3, then continue to paste the 3 in cell
"D4"
Sub Findlast()
'
Sheets("1340 $").Select
Range("A7").End(xlDown).Select
Selection.Copy
Sheets("Summary").Select
Range("D7").Select
ActiveSheet.Paste
End Sub
thanks !
I have a code that i want to adjust. It currently goes to the bottom of the specific "1360 $ " Sheet and copies last range in column A, i want to select and copy the last ranges in the column then paste it in the Summary Sheet.
It currently only posts the last cell in "1360$" is there a coded like someone can help me with to get it to instead copy last cell in Column A, COPY LAST 3, then continue to paste the 3 in cell
"D4"
Sub Findlast()
'
Sheets("1340 $").Select
Range("A7").End(xlDown).Select
Selection.Copy
Sheets("Summary").Select
Range("D7").Select
ActiveSheet.Paste
End Sub
thanks !