Copy cell contents to new cells automaticly

[enne]

Hello,
I have no experience with Excel, but I have to use it

I use a spreadsheet with 100 rows. Looks like this:

AAA | W | X | Y | Z
----------------------------
ABC | 5 | 8 | 11 | 4
DEF | 0 | 2 | 4 | 10
GHI | 3 | 68 | 7 | 34

My input (can be copied into Excel) looks like this:

-----------------------------
ABC | W | 5
ABC | X | 8
ABC | Y | 11
ABC | Z | 4
DEF | W | 0
DEF | X | 2
DEF | Y | 4
DEF | Z | 10
GHI | W | 3
GHI | X | 68
GHI | Y | 7
GHI | Z | 34

The spreadsheet is growing and now I want to save time and look for a possiblity to make the updates easier.

The macro or whatever shoud look to the input and do the following: ABC, value for W is 5, and update the correct cell on my spreadsheet and so on, until the last row of the input is reached.

Can someone give me some instruction how to do?
This message was edited by enne on 2002-05-06 06:52
This message was edited by enne on 2002-05-06 06:54
This message was edited by enne on 2002-05-06 06:57

 

[enne]

Hi Aladin,

the correct name is DATA0001 (Data1), DATA0002 (Data2), DATA0021 (Data3) and DATA0031 (Data4).

This means, the input may look like this:

___A______B________C______
1__Name__Check____Problem
2__Hugo__Data0001___5
3__Hugo__Data0002___8
4__Hugo__Data0031___4
5__John__Data0001___0
6__John__Data0002___4
7__John__Data0021___2
8__John__Data0031___10
9__Bill__Data0002___68
10_Bill__Data0021___7
11_Bill__Data0031___34

You see, the DATA0021 for Hugo and DATA0001 for Bill is missing. The maximum is three mising DATA00xx, one is at least there for every name.


The value for DATA0001 needs to be in the overview sheet in the column named DATA0001, and so on with the other columns.

Each missing DATA00xx has the value 0 per default.

Again, thanks for your help.
Stephan
This message was edited by enne on 2002-05-11 09:21

 

[Aladin Akyurek]

the correct name is DATA0001 (Data1), DATA0002 (Data2), DATA0021 (Data3) and DATA0031 (Data4).

This means, the input may look like this:

___A______B________C______
1__Name__Check____Problem
2__Hugo__Data0001___5
3__Hugo__Data0002___8
4__Hugo__Data0031___4
5__John__Data0001___0
6__John__Data0002___4
7__John__Data0021___2
8__John__Data0031___10
9__Bill__Data0002___68
10_Bill__Data0021___7
11_Bill__Data0031___34

You see, the DATA0021 for Hugo and DATA0001 for Bill is missing. The maximum is three mising DATA00xx, one is at least there for every name.


The value for DATA0001 needs to be in the overview sheet in the column named DATA0001, and so on with the other columns.

Each missing DATA00xx has the value 0 per default.

How are we supposed to infer which Data-value(s), the 1st, 2nd, 3rd, or 4th or a bunch of these values are missing?

If there is some regularity from which we can infer which individual Data-value is missing, we could perhaps tweak the formulas to cope with missing values.

Is it possible, for example, to leave the cell in B empty, if the Data-value is missing or enter something like -99999 for a missing value.

Aladin

 

[enne]

Hi Aladin,

the only think I can do is to insert the missing lines on the input sheet.