Thread: Creating multiple spreadsheets based on text
View Single Post
 
Old 04-06-2015, 11:34 AM
ksigcajun ksigcajun is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: May 2014
Posts: 76
ksigcajun is on a distinguished road
Default
Quote:
Originally Posted by charlesdh View Post
Hi,

My error. Should have tested further.
Check this copy. It should copy data to the workbook and close it. Then it should open next workbook. If the next Vendor does not exist you will get the Msgbox.
It filters, copies the data correctly, the message box is displayed and that is it.

I believe the message box is displayed because it filters on the one vendor and cant find the next Vendor?
Reply With Quote