Copying Data from One Sheet to Second Sheet on a Daily Basis, but not overwriting Data from Previous Day VBA Code

C

category58

New Member
Joined
Oct 30, 2012
Messages
1
Good morning. I read the article concerning this question but the recommended code was not working for my intended application.

I am looking for some help, please. I have an excel table for which I need to back up daily. I want to save new data (values only) each day without overwriting the data from the previous day to this second (backup) sheet. Sheet 1 is named "Dashboard" and sheet 2 is named BackupData. Any help is greatly appreciated.
 

Attachments

  • 2022-04-05_9-50-04.png
    2022-04-05_9-50-04.png
    47.9 KB · Views: 21

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

V
  • Question Question
copy from source sheet1 to destination sheet2 vba code
Replies
1
Views
245
Vishaal
V
A
  • Solved
VBA code to extract a table
Replies
5
Views
215
Anthony47
A
gymwrecker
  • Solved
Formula to copy data from one sheet to another sheet based on specific criteria
Replies
4
Views
77
Fluff
Fluff
I
  • Question Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
916
Insurance Dave
I
J
  • Solved
VBA/Macro: Adding Pivot table with connection string
Replies
1
Views
119
Jette3173
J

Forum statistics

Threads
1,223,702
Messages
6,173,961
Members
452,539
Latest member
delvey

Share this page

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