Hello fellow Excellers,
Im new here so hello and here we go and bear with me.
I have a spread sheet already with names and values. This is an example real one has (1500 names.)
New List
<tbody>
</tbody>
I now have an old (yes old) list that I want to update the new list with.
the Old List has values but I do not want to overwrite the values in the New List but in the Old List, Fred has a value that I DO want to be added.
Old List
<tbody>
</tbody>
What I'm looking for, and I'm guessing here is something like......IF cell is blank then input data, if it's not blank then do nothing.
I hope this is clear and thanks for your help.
Sprackers
Im new here so hello and here we go and bear with me.
I have a spread sheet already with names and values. This is an example real one has (1500 names.)
New List
Name | Value |
Bill | 7 |
Dave | 9 |
Fred | |
John | 4 |
<tbody>
</tbody>
I now have an old (yes old) list that I want to update the new list with.
the Old List has values but I do not want to overwrite the values in the New List but in the Old List, Fred has a value that I DO want to be added.
Old List
Names | Value |
Bill | 2 |
Dave | 6 |
Fred | 9 |
John | 1 |
<tbody>
</tbody>
What I'm looking for, and I'm guessing here is something like......IF cell is blank then input data, if it's not blank then do nothing.
I hope this is clear and thanks for your help.
Sprackers