Trains R Us
New Member
- Joined
- Nov 13, 2017
- Messages
- 1
Hoping someone can help with some good VBA code.
Situation: I have three columns: This Period. Last Period Cumulative. This Period Cumulative. I have set up my spreadsheet so that the user will only need to input "This Period" values. However, I want the spreadsheet to automatically update the Last Period Cumulative column. I was hoping someone could help with a VBA to solve this. Also, the user may submit once per month, but at any time during a certain month.
Possible solution: Copy values based on a dated cell being within a date range (Begin/End of Month) in worksheet 1 and paste the values (values only) into worksheet 2 based on a corresponding monthly column. Then I can put a conditional formula in the "Last Period Cumulative" column that calculates based on the last monthly submission data that will be in worksheet 2.
Why: This could be easily done by manually transferring the "This Period Cumulative" from the previous workbook to the current workbook's "Last Period Cumulative" column. However, Given a number of line items, the complexity of worksheets, and human error, I'd like to use math instead of humans for calculating to reduce errors.
Thanks in advance Excel Geniuses.
Best.
Situation: I have three columns: This Period. Last Period Cumulative. This Period Cumulative. I have set up my spreadsheet so that the user will only need to input "This Period" values. However, I want the spreadsheet to automatically update the Last Period Cumulative column. I was hoping someone could help with a VBA to solve this. Also, the user may submit once per month, but at any time during a certain month.
Possible solution: Copy values based on a dated cell being within a date range (Begin/End of Month) in worksheet 1 and paste the values (values only) into worksheet 2 based on a corresponding monthly column. Then I can put a conditional formula in the "Last Period Cumulative" column that calculates based on the last monthly submission data that will be in worksheet 2.
Why: This could be easily done by manually transferring the "This Period Cumulative" from the previous workbook to the current workbook's "Last Period Cumulative" column. However, Given a number of line items, the complexity of worksheets, and human error, I'd like to use math instead of humans for calculating to reduce errors.
Thanks in advance Excel Geniuses.
Best.
