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: 9

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

I
  • 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
324
Insurance Dave
I
J
  • Question
Daily summary worksheet that extracts data from up to 40 worksheets and emails the sheet as an excel attachment.
Replies
4
Views
358
juscuz419
J
E
  • Question
Copy data from a Data Entry form's table to the correct date in another tab
Replies
0
Views
120
Exceleration65
E
A
  • Question
Copy and transfer data on daily basis from one worksheet to other one.
Replies
5
Views
386
awoohaw
awoohaw
M
  • Question
VBA Code to copy rows by date from one tab to another / repeat based on new date
Replies
3
Views
275
kevin9999
K

Forum statistics

Threads
1,215,751
Messages
6,126,669
Members
449,326
Latest member
asp123

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