Excel macro
Budget: €8 – €30 EUR
I need to create a macro in excel or something that will allow me to automate this process.
1. Tab 1: this document is the one that needs to be changed by adding the "Cód. producto proveedor" column (hosted on tab 2 of excel).
2. the "Cód. producto proveedor" will be entered if:
2.1 "Nº." and "Descripción" match. That is, in row cell A44 of excel sheet 1, we see that the value "P-30-30-0006" belongs to the product "Franziskaner Weis Vidrio 0'5L C-20". Therefore, if these two conditions are fulfilled then we have to add in another column the value of "cód. producto proveedor" from the "sheet2" tab of excel.
And all these proccess need to be automatized
thanks!
1. Tab 1: this document is the one that needs to be changed by adding the "Cód. producto proveedor" column (hosted on tab 2 of excel).
2. the "Cód. producto proveedor" will be entered if:
2.1 "Nº." and "Descripción" match. That is, in row cell A44 of excel sheet 1, we see that the value "P-30-30-0006" belongs to the product "Franziskaner Weis Vidrio 0'5L C-20". Therefore, if these two conditions are fulfilled then we have to add in another column the value of "cód. producto proveedor" from the "sheet2" tab of excel.
And all these proccess need to be automatized
thanks!