Thread: Creating multiple spreadsheets based on text
View Single Post
 
Old 04-06-2015, 11:05 AM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
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.
Attached Files
File Type: xlsm Test Data1.xlsm (22.2 KB, 7 views)
Reply With Quote