Forum Discussion
Govvy
Nov 10, 2022Copper Contributor
Cold flu sheet
I've had a number of colds and after covid, I was thinking I would like to record over the course of a year when I have a cold. I wasn't sure how I should be inputting my data into a sheet. I wanted ...
HansVogelaar
Nov 10, 2022MVP
Check out the attached workbooks. The area highlighted in green is where you enter the data.
Govvy
Nov 10, 2022Copper Contributor
HansVogelaar You have literally put a whole year down of dates, is the a quick way to do that?
- HansVogelaarNov 10, 2022MVP
I entered the 1st of January. With that cell selected, I clicked Fill > Series... in the Editing group on the Home tab of the ribbon.
In the dialog, I selected Columns, and entered the 31st of December in the "Stop value" box, then clicked OK.