Claire9079
New Member
- Joined
- Jun 3, 2019
- Messages
- 6
- Office Version
- 2007
- Platform
- Windows
Hi Guys,
i am new to VBA. Would be much appreciated if you could help me with this!!
I have a table with list of consultant names and their start and end date. The lastest and correct date on the spreadsheet i received is alwaysi ncluded in the Name. I would like a VBA to be able to find this date and populate into the columns "Start date" and "end date" on the right. Examples below.
Before
After
is it possible to do this? Thanks for your help in advance!!
i am new to VBA. Would be much appreciated if you could help me with this!!
I have a table with list of consultant names and their start and end date. The lastest and correct date on the spreadsheet i received is alwaysi ncluded in the Name. I would like a VBA to be able to find this date and populate into the columns "Start date" and "end date" on the right. Examples below.
Before
Name | Start date | end date |
Emily | 01/01/2021 | 31/12/2021 |
Jason (09/06/2021 - 20/06/2021) | 01/01/2021 | 31/12/2021 |
Mike | 01/01/2021 | 31/12/2021 |
After
Name | Start date | end date |
Emily | 01/01/2021 | 31/12/2021 |
Jason (09/06/2021 - 20/06/2021) | 09/06/2021 | 20/06/2021 |
Mike (01/06/2021 - 10/06/2021) | 01/06/2021 | 10/06/2021 |
is it possible to do this? Thanks for your help in advance!!