Hi team, I've been having a great deal of trouble trying to put together what should be a relatively simple worksheet!
I have managed to work out most of the individual steps but things break down when I try to combine them.
My goal is to enter a name followed by 2 dates (initial and end) (this I can do!)
Then the worksheet should look for the name (column B) and record all dates between the initial and end date in the first empty cell alongside that name.
I've tried all sorts of combinations starting with Index and Match but can't figure out how to first identify the correct row (based on name) then the first empty cell in that row, then enter the appropriate dates from that cell onwards.
Names will typically be added to the list over time. Dates will be added over time and max out at 60 entries.
If someone can help me out with some VBA magic it will be much appreciated!
I have managed to work out most of the individual steps but things break down when I try to combine them.
My goal is to enter a name followed by 2 dates (initial and end) (this I can do!)
Then the worksheet should look for the name (column B) and record all dates between the initial and end date in the first empty cell alongside that name.
I've tried all sorts of combinations starting with Index and Match but can't figure out how to first identify the correct row (based on name) then the first empty cell in that row, then enter the appropriate dates from that cell onwards.
Names will typically be added to the list over time. Dates will be added over time and max out at 60 entries.
If someone can help me out with some VBA magic it will be much appreciated!