Originally Posted by
acerlaptop
Hi everyone. (Sorry can't attach file sample due to privacy setting of my company)
I have a report that has a Data Validation (drop down) in worksheet "TEMPLATE" cell "B1". What I do is I change the value of B1 and the rest of the sheet updates based on formula. Then I save it to PDF (only the TEMPLATE worksheet) with the filename set as the VALUE of B1 to a certain folder in my local drive.
Then I repeat the process until all the list is done.
What I what to do is to automate the process using MACRO if possible.
NOTE: It doesn't have to be a validation. As long as all data in my list are accounted. My list is in worksheet "VALIDATION" cell "A:A"
Thank you
Bookmarks