Copy and transfer data on daily basis from one worksheet to other one.

[asyamonique]

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.

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

 

[Skybluekid]

Have a sample of the data?

 

[asyamonique]

ID#	NAME & SURNAME	POINT	TICKETS
1449	XXXXXX XXXXXXXX	235	2
32100	XXXXXX XXXXXXXX	287	2
34855	XXXXXX XXXXXXXX	100	1
2517	XXXXXX XXXXXXXX	136	1
34868	XXXXXX XXXXXXXX	100	1
34875	XXXXXX XXXXXXXX	28
31416	XXXXXX XXXXXXXX	235	2
10619	XXXXXX XXXXXXXX	287	2
10628	XXXXXX XXXXXXXX	100	1
34863	XXXXXX XXXXXXXX	136	1
12212	XXXXXX XXXXXXXX	100	1
34871	XXXXXX XXXXXXXX	28
704	XXXXXX XXXXXXXX	235	2
34828	XXXXXX XXXXXXXX	287	2
26735	XXXXXX XXXXXXXX	100	1
33865	XXXXXX XXXXXXXX	136	1
34839	XXXXXX XXXXXXXX	100	1
678	XXXXXX XXXXXXXX	28
14956	XXXXXX XXXXXXXX	110	1
4862	XXXXXX XXXXXXXX	301	3
33071	XXXXXX XXXXXXXX	1,520	10

 

[awoohaw]

You can do this simply and quickly with Power Query. You just need to set up how the file is found and set up the rules for transforming your data.
Mr. Excel has a chat group called Power Tools that can help you with questions there
And there are many excel you tube channels that have lots of tutorials on it.
Mr. Excel, ExcelIsFun, MyOnlineTrainingHub, and Leila Gharani

Here is the Power Query tutorial playlist for MyOnlineTrainingHub:

https://www.youtube.com/playlist?list=PLmd91OWgLVSKnVrL0YxdOH61MAiqlFHac

 

[asyamonique]

So with simply vba code we cannot do that?

 

[awoohaw]

So with simply vba code we cannot do that?

you probably can, but why? How long will it take you to write that code? Will you need to update it each month?
Watch the playlist on getting data from different files. Learning it is easier than learning VBA.