I've been trying to figure out how I could get data from a sheet onto
another one. For instance, I have ABC.XLS which contains sheet 1 and
sheet 2. Every week I generate another excel file (DEF.XLS) with my
source data and I'd like to update ABC.XLS (Sheet1 & Sheet 2). It's
not as simple as referencing the cells because the information I added
last week is to remain static and should not change when I do the
following week's update. Below is an illustration of how my sheet is
set up:

Result sheet:

Cycle1 Cycle2 Cycle3 Cycle4 Total April 7, 2004
Cycle 1 Product 1 1.2 3.4 7.8 7.8
Product 2 1.5 6.5 1.1 1.1
Total 2.7 9.9 8.9 8.9

Cycle 2 Product 1 1.2 5.4 5.4
Product 2 2.3 4.5 4.5
Total 4.5 9.9 9.9

Cycle 3 Product 1 1.9 1.9
Product 2 5.1 5.1
Total 7.0 7.0

Cycle 4 Product 1
Product 2
Total



As you can see, the the data doesn't get updated on a continuous
column/row in the result spreadsheet.
The data source sheet looks as follows:


Cycle 4 Total April 7, 2004
Cycle 1 Product 1 7.8 7.8
Product 2 1.1 1.1
Total 8.9 8.9

Cycle 2 Product 1 5.4 5.4
Product 2 4.5 4.5
Total 9.9 9.9

Cycle 3 Product 1 1.9 1.9
Product 2 5.1 5.1
Total 7 7

Cycle 4 Product 1
Product 2
Total

Is there anything you may recommend me to use? I've used some VBA
code here and there, but I'm not a expert; however, this process takes
a lot of my time each week mainly doing copy/paste, so I'm willing to
read up on and practice whatever function/procedures/events you may
recommend me to look at.

Thanks in advance for your help!

Mildred Rodriguez

There are a couple of tricks you could try. VBA has some very usful functions, which you should read up on. Try recording a macro of what you are doing, this will give you a starting point. Then you just need to modify it to suit your needs.