Hi,

I have an excel file (file 1) with forecasts for several sales channels. Every month I'm coping each sales channels data to a file specific to that sale channel (file 2,3,4,etc). These files are already existing, i.e. they are beeing updated with new data each month. It would be great if a macro could help me with this.

File 1

sale channel A / customer X / month / quantity
sale channel A / customer Y/ month / quantity
sale channel B / customer X/ month / quantity
sale channel B / customer Y/ month / quantity
sale channel C / customer X/ month / quantity
sale channel C / customer Y/ month / quantity

The number of sales channels are the same all the time (about 30) but the number of customers change (for diffrent customers and for diffrent months) so there are no specific amount of rows in each sales channel. The whole row are copied to the specific sale channel file.

File 2

sale channel A / customer X / month / quantity
sale channel A / customer Y/ month / quantity

File 3

sale channel B / customer X / month / quantity
sale channel B / customer Y/ month / quantity

etc.

Each sale channels file have some general information at the top and then at row 17 and the ones below the sales data are located. The data that is in the sales files from previous months should be deleted and replaced with new data from the forecast file (file1).

Thanks in advace!
//Martin

P.S There is a next step to this which is the oposite to the above - the sales files are sent to sales managers who do changes and send them back to me - I then combined all sales chanels files to the forecast file. I have seen some threads about this so I think I can manage that one :-)