Hi all

I am trying to create a macro that copies from a txt file into excel but it
does not work.

I have a excel file with 12 sheets (one for each month) and in each 5
columns headed
year, period,account,location,value.

I want it to get info from a txt file that may change every month and paste
it in columns C,D and E.
The problem is that it doesn't give me the chance to, everytime I run it,
choose what tab to paste it to.
Is there a way to create this macro?

Any help would be very much appreciated. I have excel 2000 pro.

Thanks