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
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