I have some work, in an Excel spreadsheet. Good day:
I have a spreadsheet where I have data in one tab for the month of May.
I also have separate tabs for each day of the week (Sunday, Monday, etc.,) and another tab for each week of the month (1st week of May, 2nd week of May, etc.,).
I would like a way for data to be read from the month tab, in this case its May and to do the following:
1. If a time exists for a particular day of the week, for the data in that row to be pulled and populated to the corresponding day of the week tab.
2. I have a start and stop column which contains dates. E.g., 06-Apr-16 in one cell and 02-Jun-16 in another cell as part of their row. I would like for the data to be pulled and populated to the corresponding week of the month. In this case, data in this row would be pulled and populated for each tab (1st week of May, 2nd week of May, etc.,) since the data falls for every week in the month of May.