Microsoft Office Forums - View Single Post - Creating multiple spreadsheets based on text

Thread: Creating multiple spreadsheets based on text

View Single Post

Old

04-15-2015, 09:54 AM

charlesdh

charlesdh is offline

charlesdh uses Windows 7 32bit

Windows 7 32bit charlesdh uses Office 2010 32bit

charlesdh uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

charlesdh is on a distinguished road

Default

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.

Reply With Quote