Gurus,
I am an excel user but new to programming excel. Here is my requirement and
need your help.

I have a text file that has the following format.

City ReportedCrimes UnreportedCrimes
Jackson 4 3
Florence 3 3
Newark 6 4

I get the report every week.

I have an excel that has worksheets by citynames. ie. jackson, florence
and newark. Each work sheet has the same format as above text file. (i.e
columns)

Here is what i want.
(a)Every week when i get the report i want a macro which upon clicking take
the text file as input , and add a row in the respective city worksheets. So
the worksheets will have all the data each week in a row.

How can i do this. Please give me sample code.

Truely appreciate your help

Regards,
Anvoice