About Us

jerrycollins6

Quote:

Originally Posted by Ben McClave

Jerry,

You have "sFind" in your code twice. The second time it is assigning the value in cell A1 (which is just the number, not the text). Does your message box display the correct name? If so, simply delete this line from your code:

sFind = ThisWorkbook.Sheets("Home").Range("A1").Value

Ben

Hi Ben ,

I have made some new modifications in the code.
So basically, I choose "Supplier/customer" then the code will export row one in ICD , and find in it the rows related to the word.

However I ve been asked to be able to choose the column.

Say: row one contains the name of the informations.

So, after choosing the word and before clicking on export, I need to be able to choose the column (information) to export. A kind of form where user can select it

Let me know if you understand what I am saying.

Best Regards

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I export a row of data into its own workbook	LMM_0809	Excel Worksheet Functions	1	August 27th 09 04:03 PM
How do I export data from a workbook to an email	A Rutherford	Excel Discussion (Misc queries)	1	May 19th 09 07:22 PM
import/export data from a workbook	ajn	Excel Discussion (Misc queries)	1	December 8th 06 01:44 PM
How to export data to a closed Workbook	newbie[_4_]	Excel Programming	1	July 20th 05 09:57 AM
Create workbook for data export and then data import?	Kevin G[_2_]	Excel Programming	0	February 4th 04 04:10 AM

Menu

About Us