Macro for add row and date information Help!

Kristabelle666

New Member
Joined
Feb 8, 2022
Messages
1
Office Version
  1. 2019
Platform
  1. 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

Data Sample.xlsx
ABCDEFGHIJKLMN
1TermCodeCampusCRNSubjCrseSectionCrseTitleMajrDisplayMeetStartDateMeetEndDateMeetDaysDisplayStartTimeEndTimeRoomDisplay
2202130MC Main Campus33077BAKE228IBakery FundamentalsBPA Baking and Pastry Arts3/23/20224/8/2022Wednesday7:30:00 AM8:20:00 AMONLINE
3202130MC Main Campus33077BAKE228IBakery FundamentalsBPA Baking and Pastry Arts3/23/20224/8/2022Friday7:30:00 AM8:20:00 AMONLINE
4202130MC Main Campus33076BAKE228HBakery FundamentalsBPA Baking and Pastry Arts3/22/20224/7/2022Tuesday7:30:00 AM8:20:00 AMONLINE
5202130MC Main Campus33076BAKE228HBakery FundamentalsBPA Baking and Pastry Arts3/22/20224/7/2022Thursday7:30:00 AM8:20:00 AMONLINE
6202130MC Main Campus33074BAKE228FBakery FundamentalsBPA Baking and Pastry Arts3/23/20223/23/2022Wednesday7:30:00 AM8:50:00 AMONLINE
7202130MC Main Campus33076BAKE228HBakery FundamentalsBPA Baking and Pastry Arts3/23/20223/23/2022Wednesday7:30:00 AM8:50:00 AMONLINE
8202130MC Main Campus33075BAKE228GBakery FundamentalsBPA Baking and Pastry Arts3/22/20223/22/2022Tuesday7:30:00 AM8:50:00 AMONLINE
9202130MC Main Campus33077BAKE228IBakery FundamentalsBPA Baking and Pastry Arts3/22/20223/22/2022Tuesday7:30:00 AM8:50:00 AMONLINE
10202130MC Main Campus33057BAKE300EArt of ChocolateBPA Baking and Pastry Arts1/31/20222/4/2022Monday7:00:00 AM9:20:00 AMONLINE
11202130MC Main Campus32979BAKE253ACapstone Year 1BPA Baking and Pastry Arts4/14/20224/21/2022Thursday8:00:00 AM9:50:00 AMONLINE
Sheet3
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top