M
Mike375
Guest
paste append adds rows to a table. betheball needs to update the existing rows.
Agree and surely anyone knows that. So it is either applicable or it is not applicable.
The Setvalues solution said it didn't need conditions - it does. You don't want to replace a non-null value with a null.
But that is what he wants. If there is a value for T1 he wants it in a new column called T5. If you don't move T1 across the row because T5 is Null then where do you put it. Only one answer, you need another row and we know tat can't be any good because that is why you knocked copy and paste append. Read his post again and all the records on T5 will be Null to start with.
"In my current table structure, there is a set of four columns named, hpothetically, T1, T2, T3 and T4. For each record only one column has a value. The rest are blank. I've decided that is a bad idea. So I am creating a new column, T5. Is there a way to merge the data from the four existing columns to the new column? "
So why does the macro need conditions. So what is convulted about the solution. Why not criticise Malcys solution which is a waste of time since T2 will rub out the T1 update and etc.
What conditions would you place on the Setvalues...That T5 is not Null. That would be just great!!!! since he made a new column with no entries.
I will bet this is what he has:
T1......T2....T3.....T4.....T5
X
..........Y
Z
.................A
.........................B
C
................D
Etc.
If T5 is to be a "stand alone" with entries not relating to other entries then copy, paste append and delete the the empty records is easily the quickest.
If the values have to be moved sideways to T5 then give me a quicker and better way than the macros.
And again, I would just love to know what conditions you would place on the SetValue. Obviously the only condition is one that stops the SetValue. But that would defeat what he wants to do.
Mike
Agree and surely anyone knows that. So it is either applicable or it is not applicable.
The Setvalues solution said it didn't need conditions - it does. You don't want to replace a non-null value with a null.
But that is what he wants. If there is a value for T1 he wants it in a new column called T5. If you don't move T1 across the row because T5 is Null then where do you put it. Only one answer, you need another row and we know tat can't be any good because that is why you knocked copy and paste append. Read his post again and all the records on T5 will be Null to start with.
"In my current table structure, there is a set of four columns named, hpothetically, T1, T2, T3 and T4. For each record only one column has a value. The rest are blank. I've decided that is a bad idea. So I am creating a new column, T5. Is there a way to merge the data from the four existing columns to the new column? "
So why does the macro need conditions. So what is convulted about the solution. Why not criticise Malcys solution which is a waste of time since T2 will rub out the T1 update and etc.
What conditions would you place on the Setvalues...That T5 is not Null. That would be just great!!!! since he made a new column with no entries.
I will bet this is what he has:
T1......T2....T3.....T4.....T5
X
..........Y
Z
.................A
.........................B
C
................D
Etc.
If T5 is to be a "stand alone" with entries not relating to other entries then copy, paste append and delete the the empty records is easily the quickest.
If the values have to be moved sideways to T5 then give me a quicker and better way than the macros.
And again, I would just love to know what conditions you would place on the SetValue. Obviously the only condition is one that stops the SetValue. But that would defeat what he wants to do.
Mike
Last edited:
