Thread: Creating multiple spreadsheets based on text
View Single Post
 
Old 04-15-2015, 10:13 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,

The reason the data is not going to the Vendor file sheet is because the code you modified from "Sheet1, sheet2" to "Declaration , Product List". The template has sheet1 and sheet2.
If you change the sheet names to "Declaration , Product List". the code should work.
Thats right. Thanks for finding the error.

Ill edit that and test again.
Reply With Quote