Macro to move rows by date to new workbook and save as custom name

Jpizzadude

New Member
Joined
Jul 12, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,

Is there a Macro that would move each row with same session start date to a new workbook and then save to a folder with the name of the workbook as Course name and Session start date?


Course NameUsernameFull NameSession Start DateSession End DateAttendance
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS248658John Smith2022-07-13 08:00:002022-07-13 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS235203John Smith2022-07-13 08:00:002022-07-13 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS425167John Smith2022-07-13 08:00:002022-07-13 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS371079John Smith2022-07-13 08:00:002022-07-13 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS205543John Smith2022-07-13 12:00:002022-07-13 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS367338John Smith2022-07-13 12:00:002022-07-13 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS302245John Smith2022-07-13 12:00:002022-07-13 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS350046John Smith2022-07-13 12:00:002022-07-13 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS361814John Smith2022-07-13 16:00:002022-07-13 18:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS222437John Smith2022-07-13 16:00:002022-07-13 18:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS206910John Smith2022-07-13 16:00:002022-07-13 18:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS244743John Smith2022-07-14 05:00:002022-07-14 07:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS428966John Smith2022-07-14 05:00:002022-07-14 07:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS310146John Smith2022-07-14 05:00:002022-07-14 07:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS311726John Smith2022-07-14 09:00:002022-07-14 11:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS271973John Smith2022-07-14 09:00:002022-07-14 11:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS282491John Smith2022-07-14 09:00:002022-07-14 11:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS424396John Smith2022-07-15 08:00:002022-07-15 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS315931John Smith2022-07-15 08:00:002022-07-15 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS299164John Smith2022-07-15 08:00:002022-07-15 10:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS367981John Smith2022-07-15 12:00:002022-07-15 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS349951John Smith2022-07-15 12:00:002022-07-15 14:00:00
Handling Pressure | Supervisor Fundamentals Series | VILT 2 HOURS350351John Smith2022-07-15 12:00:002022-07-15 14:00:00
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,215,764
Messages
6,126,748
Members
449,335
Latest member
Tanne

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