Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Automatic snapshot of data in excel triggers on a date

Posted on 2016-11-16
3
Medium Priority
?
135 Views
Last Modified: 2016-11-17
I need to capture the overall Dept percentages of Current, Expiring Soon, Expired, and Not Req'd training on a Monthly Basis in order to track whether we are improving on a month-to-month basis. Because November isn't finished yet, all percentages are considered applicable to October until month end.

These may change all month long whenever I update the spreadsheet until the month changes, then they need to become a snapshot as at the last day of the month. So column H 11-15 needs to be copied to Monthly Department Percentages at each month end.
Can this be done automatically?
Excel-Sheet-Query.xlsx
0
Comment
Question by:esbyrt
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
Roy Cox earned 2000 total points
ID: 41890926
The easiest way would be to simply have a button to run a month end copying procedure to the summary. This would paste values only, see the example.

It might be possible to have Excel run it when the month changes, but this code would run regardless of whether the updates have been made, I think pressing the button is safest.
Excel-Sheet-Query.xlsm
0
 

Author Closing Comment

by:esbyrt
ID: 41892323
Thanks, I think you are right. There are some occasions where all the data hasn't been entered before month end so an automated total might not be accurate. Thanks so much!
0
 
LVL 22

Expert Comment

by:Roy Cox
ID: 41892507
Pleased to help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question