troubleshooting Question

Excel macro to copy column E into today's date column and carry forward every day.

Avatar of chris pike
chris pikeFlag for Canada asked on
Microsoft ExcelMicrosoft Office
34 Comments1 Solution57 ViewsLast Modified:
I have a sheet that needs two buttons (macros added, one simple one to add a value into each cell beside the names, and a second to add contents of an entire column into todays column.
Have a look.
The sheet has a macro to add the values from the total points column to today and everyday after.
Whatever is in column "E" will be placed in "Todays" date column. I think if there is a button to send to "Today" that would be ok.
The set base # is easy
Everytime you need to send column E to Today there is a reason. (see Anita "Row 5"... she went from 1.5 points to 3 points, we need a note that says "on nov 30 Anita became goalie), or something I will need to put a custom note in here. )  We need to be able to capture that reason, with date, somehow.
Column E  needs to push to "Todays" column when a change is made29165634.xlsm
Join our community to see this answer!
Unlock 1 Answer and 34 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 34 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros