Forum

Notifications
Clear all

Replace a certain row's data with another

4 Posts
3 Users
0 Reactions
65 Views
(@artemis)
Posts: 6
Active Member
Topic starter
 

Hi, so I need help w how to solve this:
I will have two columns of ID numbers that do not match, the code goes to a column w a list of all ID numbers. Then the code replaces the info in the corresponding row of the second unmatching code with the info of the first unmatching code. 

 
Posted : 18/04/2021 6:38 am
(@catalinb)
Posts: 1937
Member Admin
 

Not following what you mean.

Can you please try again with more data examples?

 
Posted : 19/04/2021 12:45 am
(@artemis)
Posts: 6
Active Member
Topic starter
 

I just want to interchange the data of the two rows. Is it possible to store the value of one row in a variable and equate it to the bottom row?

 
Posted : 19/04/2021 2:26 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Arte,

I don't get it either. I have no idea where the numbers 10046 and 46 comes from in your example file. Please provide a more comprehensive example file and explain using references to the cells in the file what you want to do.

Thanks,

Mynda

 
Posted : 19/04/2021 7:10 pm
Share: