I've got two problems. The first is that I'm dutch so my English is not very good, but you can't do a thing about that. The second is the following:
I've got a spreadsheet which looks like this:
A B C D E
1 0 val2 val3 val4 val5
2 1 val2 val3 val4 val5
3 0 val2 val3 val4 val5
4 1 val2 val3 val4 val5
5 2 val2 val3 val4 val5
...
I'm searching for a vba-code and/or a macro which does the following:
when cell A1 >0 then add a line directly under it and copy val5 of the previous line (cell E1) in cel B2.
Then the value in cell A2 must be cell A1+1 and so on except when the next value is equal to 0.
It's a complicated problem (for me) but the answer is simple (i guess??). This is useally the case.
Theo
I've got a spreadsheet which looks like this:
A B C D E
1 0 val2 val3 val4 val5
2 1 val2 val3 val4 val5
3 0 val2 val3 val4 val5
4 1 val2 val3 val4 val5
5 2 val2 val3 val4 val5
...
I'm searching for a vba-code and/or a macro which does the following:
when cell A1 >0 then add a line directly under it and copy val5 of the previous line (cell E1) in cel B2.
Then the value in cell A2 must be cell A1+1 and so on except when the next value is equal to 0.
It's a complicated problem (for me) but the answer is simple (i guess??). This is useally the case.
Theo