Creating multiple spreadsheets based on text

ksigcajun · #1 04-06-2015, 07:21 AM

Quote:

Originally Posted by charlesdh

HI,

I also changed the way the program looks at it's path. I set it to "Thisworkbooks path"
So any and all file that you run the code for must be in the same and folder on your hard drive.
Also, how go you input your data?

I tested the macro last night and this morning. Once I run it, it filters on the first vendor, the message box pops up, but that is it. It doesnt copy any information to the sheets.

Am I doing something wrong?

Thanks!

ksigcajun · #2 04-06-2015, 10:47 AM

I was able to get the macro to run. Is there any way you can add a save as function after it runs for a vendor?

Lastly, can you make Sheet2 clear before adding new data for each Vendor? Right now it keeps adding it to the next row.

Thanks!

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