asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,286
- Office Version
- 2013
- Platform
- Windows
Good Day,
Worksheet named "MASTER" datas located all the way down from the cells AE3:AH
I've created the below code by recording option to explain my request better way
I'm exporting those datas from different platform, its ranges always changing.
Simply I like to copy those datas from the worksheet"MASTER" to other worksheet "TOTAL"
Is it possible that the code will get always whatever data I have in "MASTER" AE3:AH
And will insert to worksheet "TOTAL" A2:D ranges all the way down from the last row.
Sample:
Date01 AE3:AH20 has data and need to transfer to worksheets "TOTAL" A2:D
Date02 AE3:AH50 has data and need to transfer to worksheets "TOTAL" A18:D63 coz last data was on A18 cell.
Hope its clear.
Thanks a lot.
Worksheet named "MASTER" datas located all the way down from the cells AE3:AH
I've created the below code by recording option to explain my request better way
I'm exporting those datas from different platform, its ranges always changing.
Simply I like to copy those datas from the worksheet"MASTER" to other worksheet "TOTAL"
Is it possible that the code will get always whatever data I have in "MASTER" AE3:AH
And will insert to worksheet "TOTAL" A2:D ranges all the way down from the last row.
Sample:
Date01 AE3:AH20 has data and need to transfer to worksheets "TOTAL" A2:D
Date02 AE3:AH50 has data and need to transfer to worksheets "TOTAL" A18:D63 coz last data was on A18 cell.
Hope its clear.
Thanks a lot.
VBA Code:
Range("AE5:AH1000").Select
Selection.Copy
Sheets("TOTAL").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select