Kristabelle666
New Member
- Joined
- Feb 8, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
SO I have a weird question and I am terrible at Macros.
Basically I need a macro that can take a row from this data below, see how many of the day of the week (Meetdaysdisplay) are between the two dates (MeetStartDate and MeetEndDate), add a row and the other information in the initial row for each of those Mondays or Tuesday or whatever, and THEN fill in the Meet start date and meet end date with the singular date.
Example: The first row of data is Wednesdays from 3/23/2022 - 4/8/2022
I would need 3 rows of the same data and those three rows would have meetstartdate and meetenddate of 3/23/2022, 3/30/2022 and 4/6/2022 respectively.
Basically I want each day that this class is held to be an individual entry in the table.
Plz halp
Basically I need a macro that can take a row from this data below, see how many of the day of the week (Meetdaysdisplay) are between the two dates (MeetStartDate and MeetEndDate), add a row and the other information in the initial row for each of those Mondays or Tuesday or whatever, and THEN fill in the Meet start date and meet end date with the singular date.
Example: The first row of data is Wednesdays from 3/23/2022 - 4/8/2022
I would need 3 rows of the same data and those three rows would have meetstartdate and meetenddate of 3/23/2022, 3/30/2022 and 4/6/2022 respectively.
Basically I want each day that this class is held to be an individual entry in the table.
Plz halp
Data Sample.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | TermCode | Campus | CRN | Subj | Crse | Section | CrseTitle | MajrDisplay | MeetStartDate | MeetEndDate | MeetDaysDisplay | StartTime | EndTime | RoomDisplay | ||
2 | 202130 | MC Main Campus | 33077 | BAKE | 228 | I | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/23/2022 | 4/8/2022 | Wednesday | 7:30:00 AM | 8:20:00 AM | ONLINE | ||
3 | 202130 | MC Main Campus | 33077 | BAKE | 228 | I | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/23/2022 | 4/8/2022 | Friday | 7:30:00 AM | 8:20:00 AM | ONLINE | ||
4 | 202130 | MC Main Campus | 33076 | BAKE | 228 | H | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/22/2022 | 4/7/2022 | Tuesday | 7:30:00 AM | 8:20:00 AM | ONLINE | ||
5 | 202130 | MC Main Campus | 33076 | BAKE | 228 | H | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/22/2022 | 4/7/2022 | Thursday | 7:30:00 AM | 8:20:00 AM | ONLINE | ||
6 | 202130 | MC Main Campus | 33074 | BAKE | 228 | F | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/23/2022 | 3/23/2022 | Wednesday | 7:30:00 AM | 8:50:00 AM | ONLINE | ||
7 | 202130 | MC Main Campus | 33076 | BAKE | 228 | H | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/23/2022 | 3/23/2022 | Wednesday | 7:30:00 AM | 8:50:00 AM | ONLINE | ||
8 | 202130 | MC Main Campus | 33075 | BAKE | 228 | G | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/22/2022 | 3/22/2022 | Tuesday | 7:30:00 AM | 8:50:00 AM | ONLINE | ||
9 | 202130 | MC Main Campus | 33077 | BAKE | 228 | I | Bakery Fundamentals | BPA Baking and Pastry Arts | 3/22/2022 | 3/22/2022 | Tuesday | 7:30:00 AM | 8:50:00 AM | ONLINE | ||
10 | 202130 | MC Main Campus | 33057 | BAKE | 300 | E | Art of Chocolate | BPA Baking and Pastry Arts | 1/31/2022 | 2/4/2022 | Monday | 7:00:00 AM | 9:20:00 AM | ONLINE | ||
11 | 202130 | MC Main Campus | 32979 | BAKE | 253 | A | Capstone Year 1 | BPA Baking and Pastry Arts | 4/14/2022 | 4/21/2022 | Thursday | 8:00:00 AM | 9:50:00 AM | ONLINE | ||
Sheet3 |