Hi all
I have a load of data that I need to upload to a new system using a new customer account number, and with only basic levels of knowledge in excel I was hoping that someone may be able to help or point me in the right direction to research how to do it.
The data is split into a large number of sheets with the only unique field in each sheet being the old account number and the new account number only showing on the first sheet. I need to pull the new account number over to all the other sheets but there maybe more than one line of the same account number on sheet 2, sheet 3 etc due to multiple properties for that one customers account number. It could also be the case that there is no data on Sheet 2, Sheet 3 etc for the Sheet 1 Account Number due to data deletion.
Sheet 1
<colgroup><col width="152" style="width:114pt"> <col width="152" style="width:114pt"> <col width="152" style="width:114pt"> </colgroup><tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Many thanks
I have a load of data that I need to upload to a new system using a new customer account number, and with only basic levels of knowledge in excel I was hoping that someone may be able to help or point me in the right direction to research how to do it.
The data is split into a large number of sheets with the only unique field in each sheet being the old account number and the new account number only showing on the first sheet. I need to pull the new account number over to all the other sheets but there maybe more than one line of the same account number on sheet 2, sheet 3 etc due to multiple properties for that one customers account number. It could also be the case that there is no data on Sheet 2, Sheet 3 etc for the Sheet 1 Account Number due to data deletion.
Sheet 1
NEW Cust ID | Account_Customer | OLD Account_No |
111 | No | A53821 |
112 | Yes | A53822 |
113 | No | AAC00001 |
114 | Yes | ABB00001 |
115 | No | ACC00001 |
116 | Yes | ADD00001 |
117 | Yes | ADI00001 |
118 | No | ADL00001 |
<colgroup><col width="152" style="width:114pt"> <col width="152" style="width:114pt"> <col width="152" style="width:114pt"> </colgroup><tbody>
</tbody>
Sheet 2
NEW Cust ID | OLD Account_No |
A53822 | |
000537 | |
ATF00001 | |
AAC00001 | |
ABB00001 | |
ABB00001 | |
ABB00001 | |
ACC00001 | |
ADD00001 |
<tbody>
</tbody>
Many thanks