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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

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