Hi experts,
I have a very similar situation to this post http://www.mrexcel.com/forum/excel-...hrough-drop-down-list-creating-pdf-files.html
I successfully use the code posted in that thread referenced to create a file for each item in the dropdown list.
PROBLEM:
My dropdown list is "store number" which are stored as text (eg 00202).
I believe when the code loops through, it changes the validation list from text to numbers and resulted in the data not updating.
In other words, every file came up to have blank cells/charts.
Please help me solve this.
Thanks!!
I have a very similar situation to this post http://www.mrexcel.com/forum/excel-...hrough-drop-down-list-creating-pdf-files.html
I successfully use the code posted in that thread referenced to create a file for each item in the dropdown list.
PROBLEM:
My dropdown list is "store number" which are stored as text (eg 00202).
I believe when the code loops through, it changes the validation list from text to numbers and resulted in the data not updating.
In other words, every file came up to have blank cells/charts.
Please help me solve this.
Thanks!!