Creating multiple spreadsheets based on text

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Creating multiple spreadsheets based on text

FAQ

Thread Tools

Display Modes

#11

04-06-2015, 11:34 AM

ksigcajun

Windows 7 64bit Creating multiple spreadsheets based on text

Office 2010 64bit

Advanced Beginner

Join Date: May 2014

Posts: 76

Quote:

Originally Posted by charlesdh

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a table that automatically updates based on entries of a heading in the document	cahphoenix	Word	3	10-29-2014 01:11 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Need help creating a Word document that is populated based on certain selected values	alidaanish	Word	1	01-10-2014 10:44 PM
Creating Report based on 'Task Summary' and 'Sub Tasks'	alijahed	Project	1	02-01-2013 04:20 AM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM