inport txt file automatically
Account Number Name 1 Property Address 1 wk1 wk2
1000192872 Mrs Sarah McLaren 1 Aitken Lane
I have an excel spreadsheet of above with 5000 account numbers in column A:
each week I have to import a txt file with some of these account numbers and
the amount paid in wk1 wk2 wk3 etc.
Can anyone show me how to do this using excel vba. I've got some knowledge
but not enough to do this by myself.
Thanks all.
|