Forum Discussion
CloversBooks1993
Aug 04, 2022Copper Contributor
Auto Divide Cell Value to Specified Cells in a Column
Hi. Newbie here, hope you can help me. Im working on a spreadsheet and I have to autodivide a certain number of cases to the number of headcount we have in a day across a column in a range of cells a...
CloversBooks1993
Aug 12, 2022Copper Contributor
Thank you, Hans. What if I have a data list of all months of the year in A2, and I want to see the records I have in August so I select August right. But I also would like to view September records automatically when I select the September from A2 dropdown. Im not sure if that's a macro. But how can I make it function like that? Im not sure if Im being clear. Haha. I wish I am. Thank you again!
HansVogelaar
Aug 12, 2022MVP
My previous reply will automatically fill the days of the month you enter in A2. So if you enter August, it will enter Aug-01 to Aug-31. If you enter September, it will enter Sep-01 to Sep-30.
It doesn't fill any "records" since I don't know how that would work.
- CloversBooks1993Aug 12, 2022Copper ContributorOh, I see. Thank you so much, again and again, Hans.