troubleshooting Question

Need additional macro to clear columns with user choosing which dates to start from.

Avatar of chris pike
chris pikeFlag for Canada asked on
Microsoft ExcelMicrosoft Office
36 Comments1 Solution62 ViewsLast Modified:
I need a modification to my sheet.
Currently the sheet prompts to add data from column "E"  to all date columns from last open.

What I need now is the ability to do the same thing but from a user given date, this should clear out all previously written data with the new data from "E"

So, If the sheet was last updated Nov 1 and it is now Dec 1 ,  I need the ability to update data from Nov 15th or whatever date.
Prompt user to choose date FROM to Last date Cleardate-prompt.mp4
Join our community to see this answer!
Unlock 1 Answer and 36 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 36 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