Hi,
Could someone help me with my query please? I have attached a sample spreadsheet for reference.
I’m a novice at VBA (very, very Basic understanding of VBA) and have tried multiple attempts with no avail.
I would like to create a VBA code to allow me to do the following;
Ø Check Column K (follow up date) and see if the any cells match todays date.
Ø If query is satisfied it has found a cell with todays date, then send an email automatically to an addressee.
Ø Email to include, a comment and use information from that same row from columns C & D new line and then Previous Comments: = Column L.
Ø Once this has been done, it can only be sent once until that cell is then amended (normally a future date, and when that date becomes todays date it would send again) so the same emails are not sent every time the spreadsheet is opened in that day.
Ø This to be effective across 6 worksheets within the same work book.
Secondary query, I would also like for a query for Column G. If the date in column G is older than todays’ date (yesterday and back), then entire row is moved to ‘Archive’ worksheet on the next available row and the worksheet where the row was moved from is deleted so the spreadsheet doesn’t contain multiple gaps.
Is this possible as I’ve tried multiple versions but as I have limited experience I’m stuck.
Thank you so much in advance for any help provided.
Kind regards
Could someone help me with my query please? I have attached a sample spreadsheet for reference.
I’m a novice at VBA (very, very Basic understanding of VBA) and have tried multiple attempts with no avail.
I would like to create a VBA code to allow me to do the following;
Ø Check Column K (follow up date) and see if the any cells match todays date.
Ø If query is satisfied it has found a cell with todays date, then send an email automatically to an addressee.
Ø Email to include, a comment and use information from that same row from columns C & D new line and then Previous Comments: = Column L.
Ø Once this has been done, it can only be sent once until that cell is then amended (normally a future date, and when that date becomes todays date it would send again) so the same emails are not sent every time the spreadsheet is opened in that day.
Ø This to be effective across 6 worksheets within the same work book.
Secondary query, I would also like for a query for Column G. If the date in column G is older than todays’ date (yesterday and back), then entire row is moved to ‘Archive’ worksheet on the next available row and the worksheet where the row was moved from is deleted so the spreadsheet doesn’t contain multiple gaps.
Is this possible as I’ve tried multiple versions but as I have limited experience I’m stuck.
Thank you so much in advance for any help provided.
Kind regards