Improvement of existing Excel VBA
Budget: €6 – €12 EUR
Source File name: "Rollei Auslandbestellungen"
VBA Export button in the file creates the target file "BestellungenMail"
We have now added in the source file 2 new columns:
1) Column C (Rev.)
2) Column D (Lot)
Task 1:
The new columns in the source file shall also be added to the target file. The sequence of the columns in the target file and column description shall be same as in the source file.
Task 2:
The current VBA uses the combination of "Order Number" + "Art.No." as identification to compare old and new data (new data are marked yellow). This shall be changed as follows. "Order Number" + "Art.No." + "Rev." + "Lot" shall be the new identification.
All other aspects of the existing VBA shall not be changed but must keep working properly.
VBA Export button in the file creates the target file "BestellungenMail"
We have now added in the source file 2 new columns:
1) Column C (Rev.)
2) Column D (Lot)
Task 1:
The new columns in the source file shall also be added to the target file. The sequence of the columns in the target file and column description shall be same as in the source file.
Task 2:
The current VBA uses the combination of "Order Number" + "Art.No." as identification to compare old and new data (new data are marked yellow). This shall be changed as follows. "Order Number" + "Art.No." + "Rev." + "Lot" shall be the new identification.
All other aspects of the existing VBA shall not be changed but must keep working properly.