Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raslot
 
Posts: n/a
Default Import and Comparisson functions


Ok this is a long one so hang on :)

Im trying to create a database of a hell lot of information but all
info is devided into different files.
The files are all named like this : "Name - Item - (Date in format
Year.Month.Day) <and a random number
There are about 20 different names for it to search for and about 9000
items.
So basicly what i need is for it to find all files starting with: Name1
and Name2 and import the second line in these files into a excel sheet.
It is divided by commas like this:
500.0,10.0,9832,32767,172384569,10,1,False,2006-01-28,1,60011917,10000064,30004969,1,

Then i want it to compare the third value ( in this case 9832 ) to a
excel database were [A1] is the value shown here and [B1] is the
Correct name.
Note: A1 and B1 could be located in any other cell too so i need it to
locate the value and look at the same B cell. And ofcourse then
overwrite 9832.

// Best Regards


--
Raslot
------------------------------------------------------------------------
Raslot's Profile: http://www.excelforum.com/member.php...o&userid=30933
View this thread: http://www.excelforum.com/showthread...hreadid=506064

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"