| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Text file based on criteria
You need to create a macro linked to the worksheet_change event of your first sheet which will then lookup the value in the second sheet and then use a file open such as Open "C:\sgdkjagsd.txt" For Input As #1 Do while not EOF(1) Line input #1, FileLine Cells(65536,1).end(xlup).offset(1,0) = FileLine Loop Close #1 -- mrice ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=533614 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Importing text file | Excel Discussion (Misc queries) | |||
| Importing Text File into Excel | Excel Discussion (Misc queries) | |||
| Importing a large text file | Excel Discussion (Misc queries) | |||
| Importing text file to excel | Excel Discussion (Misc queries) | |||
Threaded Mode
