Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With ov...
HI I have got an issue I hope you can help with.
so Lets say that Cell H7 is a Monday and there are empty cells below that, I would like to be able to get the excel sheet to pull the names from the week Rota to be displayed under H7
example
From B7 to B 15 I want names to come over to H8 - H15 if H7 says Monday and yes H7's day will change as the date changes so B then goes to F7 - 15 Monday through to Friday
| Monday |
| Alex / Tariq |
| Alex / Tariq |
| Dario |
| Dario |
| Dario / Elizabeth |
| Dario / Elizabeth |
| Elizabeth |
| Elizabeth |