Creating historical version of spreadsheet

[Kingclimber]

Hi all,

Kinda fumbling my way through learning VBA/Excel. I'm going through different tutorials online and can't figure out how to do the following. Any help/tutorial links for this would be appreciated.

I have a spreadsheet with financial data under a given month. I need to put a button in, that A. checks the date so that B. if it is a Friday, it saves the values of all the fields (which are linked from other spreadsheets) and saves them in another tab with the same formatting. Effectively I want to create a timeline of week to week reports showing the changes in each field.

If someone could point me in the right direction that would be very much appreciated.

Thanks,
Wes

 

[hiker95]

Kingclimber,

Welcome to the MrExcel forum.

See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 5/30/2018

https://www.mrexcel.com/forum/excel...lding-software-excel-shipper.html#post5079095

 

[Kingclimber]

So this is what I've come up with.

Sub Savecopy()


' Save a copy of the current worksheet

Worksheets("Residential").Copy After:=Worksheets("Residential")
ActiveSheet.Name = Format(Date, "MM-YY")
With ActiveSheet.UsedRange
.Value = .Value
End With


End Sub

The problem with that though is that the main sheet loses all formulas and links. Anyone know how to adjust this so that the mainsheet maintains it's formulas and links, while the copied sheets are all value only copies?