I am trying (without success) to update a downloaded spreadsheet.
I have 2 columns of info - one with codes and another with prices.
i require to change the prices from a second spreadsheet containing the same (but not quite) codes and new prices.
some of the codes do not exist on the new upgrade and some of the prices do not need to change on the old sheet.
For instance in
A1 : : B1 and in D1 : E1
1121 : 6.99 : 1121 : 7.99
1122 : 6.99 : 1122 : 6.99
1123 : 5.00 : 1123 : 5.99
1124 : 7.00 : 1125 : 1.00
1125 : 0.99 : 1127 : 2.00
1126 : 3.33
1127 : 1.99
I need to preserve the codes and prices in A1 and B1 that dont appear in column D1 and E1 then in B1 only the prices that have changed are replaced and not the ones that dont appear in D1 E1.
then i need to save it to a csv (tab delimited) file to upload to the data base.
Thanks for any solutions.
I have 2 columns of info - one with codes and another with prices.
i require to change the prices from a second spreadsheet containing the same (but not quite) codes and new prices.
some of the codes do not exist on the new upgrade and some of the prices do not need to change on the old sheet.
For instance in
A1 : : B1 and in D1 : E1
1121 : 6.99 : 1121 : 7.99
1122 : 6.99 : 1122 : 6.99
1123 : 5.00 : 1123 : 5.99
1124 : 7.00 : 1125 : 1.00
1125 : 0.99 : 1127 : 2.00
1126 : 3.33
1127 : 1.99
I need to preserve the codes and prices in A1 and B1 that dont appear in column D1 and E1 then in B1 only the prices that have changed are replaced and not the ones that dont appear in D1 E1.
then i need to save it to a csv (tab delimited) file to upload to the data base.
Thanks for any solutions.
Last edited:
