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

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,286
Office Version
  1. 2013
Platform
  1. 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.



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
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
ID#NAME & SURNAMEPOINTTICKETS
1449XXXXXX XXXXXXXX2352
32100XXXXXX XXXXXXXX2872
34855XXXXXX XXXXXXXX1001
2517XXXXXX XXXXXXXX1361
34868XXXXXX XXXXXXXX1001
34875XXXXXX XXXXXXXX28
31416XXXXXX XXXXXXXX2352
10619XXXXXX XXXXXXXX2872
10628XXXXXX XXXXXXXX1001
34863XXXXXX XXXXXXXX1361
12212XXXXXX XXXXXXXX1001
34871XXXXXX XXXXXXXX28
704XXXXXX XXXXXXXX2352
34828XXXXXX XXXXXXXX2872
26735XXXXXX XXXXXXXX1001
33865XXXXXX XXXXXXXX1361
34839XXXXXX XXXXXXXX1001
678XXXXXX XXXXXXXX28
14956XXXXXX XXXXXXXX1101
4862XXXXXX XXXXXXXX3013
33071XXXXXX XXXXXXXX1,52010
 
Upvote 0
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:

 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top