Hello all.
I have a file updated each day with two tabs: Sheet 1 has data for daily performance for some plants I am tracking.
The second sheet has a recap that is needed to be captured each day and kept for historical & graphing purposes.
What I'm trying to do is create some VBA that, upon saving, would take the percentage values from Sheet 1 and automatically copy & paste those values in Sheet 2 into the corresponding column based on the date in Sheet 1.
I already have the VBA to save a macro upon saving but I haven't been able to figure out how to copy & paste with the condition on the date. I could copy & paste the values manually each day, but in case I forget, I can make the VBA upon saving make sure this is done for me.
Any help would be appreciated!
Thanks!
-Greg (mst3kr)
I have a file updated each day with two tabs: Sheet 1 has data for daily performance for some plants I am tracking.
Date | 1/17/22 |
Plant 1 | 8.4% |
Plant 2 | 2.6% |
Plant 3 | 3.7% |
Plant 4 | 12.4% |
Plant 5 | 6.0% |
The second sheet has a recap that is needed to be captured each day and kept for historical & graphing purposes.
1-Jan | 2-Jan | 3-Jan | 4-Jan | 5-Jan | 6-Jan | 7-Jan | 8-Jan | 9-Jan | 10-Jan | 11-Jan | 12-Jan | 13-Jan | 14-Jan | 15-Jan | 16-Jan | 17-Jan | 18-Jan | 19-Jan | 20-Jan | 21-Jan | 22-Jan | 23-Jan | 24-Jan | 25-Jan | 26-Jan | 27-Jan | 28-Jan | 29-Jan | 30-Jan | 31-Jan | |
Plant 1 | 8.40% | ||||||||||||||||||||||||||||||
Plant 2 | 2.60% | ||||||||||||||||||||||||||||||
Plant 3 | 3.70% | ||||||||||||||||||||||||||||||
Plant 4 | 12.40% | ||||||||||||||||||||||||||||||
Plant 5 | 6.00% |
What I'm trying to do is create some VBA that, upon saving, would take the percentage values from Sheet 1 and automatically copy & paste those values in Sheet 2 into the corresponding column based on the date in Sheet 1.
I already have the VBA to save a macro upon saving but I haven't been able to figure out how to copy & paste with the condition on the date. I could copy & paste the values manually each day, but in case I forget, I can make the VBA upon saving make sure this is done for me.
Any help would be appreciated!
Thanks!
-Greg (mst3kr)