VBA Code to trim form rw "O" and make filename as rw "A"

Hello,

Hope u guys can help me out.
Row A is Unique and there for better as file name.
Row O is an quantity and sometimes blank.

So i want to filter on O and than make the filenames. So the blank cells will not create a file.



Down here the code i am using.

Please Login or Register  to view this content.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.