MS EXCEL doubts

Question

I have created a list of dates using data validation. Now beside that cell, I have a form where different data is to be entered & stored in each cell based on the list of dates. On each day, I will select today's date in the list & fill the form accordingly. I should also be able to see the values I entered on earlier dates if that date is chosen.

Basically, I want a cell to store the values everyday according to the date I will be choosing from the list. I will enter the data daily and I want the excel file to sore them accordingly. How to create the code? Can I use conditional formatting? Please advice & clarify my query.

Answer 1

Hello , Anirjit

Welcome to Microsoft Community and appreciate your time taken for sharing detailed information.

Based on your description, I may need to research your files before I can come up with a solution. Can you post your files here? In this way I can better determine what is the best solution. Do not contain confidential and personal information in the file.

By the way, If you are seeking solutions like VBA or macro, I suggest you also go to Microsoft technical community to post your question.

All Questions - Microsoft Q&A

Feel free to post back if you have any additional questions.

Best Regard,

Yuhao Li| Microsoft Community Support Specialist

Answer 2

Maybe it's because you checked my private message too late. Please share your file in OneDrive and copy the link to Microsoft Community so that we can figure out a workaround. Detailed steps are listed here: Share OneDrive files and folders (microsoft.com)

Answer 3

Where to post the files? The link to attach you provided is showing as "Access Denied

You are not authorized to access this page."