Hi
I am new at this level of VBA can anyone help me
I have a wokbook with a sheet called Email, I need to match cell A3 with the correct worksheet , copy it to a new workbook, save it to the path that matches F3 with the file name in E3.
This needs to work down the list and complete all the sheets. I then need to email those new workbooks to the email addresses in the same row eg G3 -O3 the the subject and body in D3 & E3
This needs to do all the sheets matching the relevant data I have attched a sample
Thank you in advance
Penny
Bookmarks