View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shaji shaji is offline
external usenet poster
 
Posts: 28
Default import data from txt file to an existing excel file

Hi !

I have an excel file for sending salary details to bank. 1st column - empl
code no., 2nd column-Account No. and 3rd column i want to fill the salary for
the month.
I am getting the salary details through a fixex width txt file every month.
I would like to have a macro which check the employee code in the excel file
and check for the same in the txt file and return the salary of the employee
in the 3rd column in the excel file.

Thanks in advance