Is there any simple way to import a file from a TXT file automatically
by clicking a button in Excel. If not is there a way or program to
convert a txt file to excel via batch file? Basically I have this
command:

=IF(COUNTIF(Sheet2!A1:A7969,C8)0,"YES","NO")

This is asking if I enter a number in cell C8 and it equals any number
on Sheet 2 in column A
then return a YES if not NO. However this file changes daily and I
dont want to have to keep reimporting this file every day by hand and
would like it automated basically with either a click of a button or
off the name of a constant spread sheet or TXT file.

Any ideas would be GREAT!!