This macro looks for the account # and then exports that worksheet with the listed filename. However it is always saving the second row as the wrong sheet. For example, in the attached workbook there are two filenames listed on sheet 1. Sheet 2&3 are for those. It should take sheet 2 and export it with the filename in A1 and export sheet 3 with the filename in A2. It does the first export correctly, but it is exporting sheet 1 with the filename in A2. Normally there are about 210 listed filenames. They are ALL right except for the 2nd filename listed.
It is whatever is listed in A2.
Bookmarks