Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can autofill do this?
I am trying to track job postings that last for 30 day increments. The
postings can be created on any day of the month. I have the dates of the month as columns, and the postings as rows, and want to set up a sheet for each month. I want to track which day each post started and count each day the post has run going forward until it hits 30 day expiration. If the job was posted on the 5th, the cell for that row under it would read 1, the cell under the 6th would read 2, etc. until it hits 30. A colleague thought it was possible for me to go into the cell under the date each job is posted and enter "1" in the cell and autofill would then populate the next 29 cells in the row for me. He even thought it could carry over to the next sheet. So if I recorded a job as being posted on the 25th, the cells would finish out the month on that sheet and keep going on the sheet until it hits the 30 count. He has no idea how to do this, of course. Anyone here know if he is right or if something like this is even possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
question about tricky autofill for series | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
AutoFill Visible Cells with Months | New Users to Excel |