Copy and paste macro

[jethro11]

Hi,
Every week I copy and paste data from a flat file and append it to an excel spreadsheet with several worksheets. The flat file is a monthly file while the excel spreadsheet contains data for the whole year (each week the updated data from the flat file is appended to the worksheets in the spreadsheet).
The flat file contains natural gas consumption data for furnaces e.g. furnace 1, furnace 2, furnace 3, furnace 4, furnace 5, furnace 6...... The excel spreadsheet has separate worksheets for groups of furnaces e.g. furnace 1, furnace 2 , furnace 3 in worksheet 1; furnace 4, furnace 5, furnace 6 in worksheet 2 etc.
Is there a macro which can automate this task? I would greatly appreciate some help with this! Thanks!

 

[Jim North]

"is there a macro"... well no, but you can write one.

You will probably need to format the data on one worksheet and then copy it to the yearly.

The first thing is to automate the copy/paste you are doing.... have you tried importing from text file directly into excel?

 

[jethro11]

Yes, as a matter of fact I do convert the flat file into an excel spreadsheet and then copy and paste columns from that spreadsheet to the yearly spreadsheet. However the process of selecting a bunch of cells from one spreadsheet to a worksheet in another spreadsheet is very cumbersome.
The complicated part I can't figure out is this:
In the beginning of September '02 the flat file would have data for the first week which is copied and appended to the yearly spreadsheet. Next week we now have data for the first 2 weeks, but I would only copy data for the 2nd week and append it to the yearly spreadsheet. How do I prevent data being overwritten?? Thanks!

 

[hianupam]

Can you send me a sample if your excel file and the flat file. Hard to comment without taking a look at it. if you can Send it to dasa@paceglobal.com