Let me paraphrase, Freddy, to see whether I have this right. You have a date
on (say) row 2, followed by blank spaces in rows 3-17, then another date on
row 18 and so on for a week's worth of rows. You want to fill in slots in
each day's schedule from another sheet. Is that about right?
If so, the next question is: What logic should be used to determin which
slot is going to be filled in, each time? It's easy enough to do it
serially, but below it sounds like it might matter whether your program picks
slot 12 or slot 3 for a given date. Does it?
--- "Freddy" wrote:
> Microsoft Visual Basic 6.5 on Microsoft Excel 2002 SP3. I'd like assistance
> in writing code to auto-populate other cells based on a column of dates. The
> purpose is to determine what slots need to be filled for scheduling purposes.
> There are a total of, for example, 15 slots to be filled per date.
> Essentially, this is my thought process. I believe each date per row needs to
> be evaluated to see where it fits in a scheduling template which would be
> created by the user initially selecting a date using a defined name table
> then I would have the cells underneath fill in automatically 15 times then
> the 16th cell down would be the originally selected date plus one day; this
> last step would be repeated to span 7 days. Now, from another worksheet
> within the workbook, after sorting records by date, then time, then city, I
> would these copy rows into a worksheet named "Scheduler".
|
Similar Threads
