View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tanks1308[_4_] tanks1308[_4_] is offline
external usenet poster
 
Posts: 1
Default Macro to sum up the amout?

Hello, need your help to help me on this. You see I'm going to create
macro to sum up the staff salary in column C. Everytime i will receiv
a data file in txt format where the file will have a number of staff
Every month the number of staff will change. So how can I use the macr
to export the txt file and convert in excel format? Need ur help
Thanks.

For example:

in txt file

abc 1245420
bcd 2245420