changes to excel file with vba
Budget: $30 – $250 USD
1. Rename a worksheet NAME1 to NAME2
2. in Worksheet NAME2 (former NAME1):
- add a button LISTA PRODUSE NAME2 below LISTA PRODUSE NAME1
- rename FORMULAR COMANDA NAME1 to FORMULAR COMANDA
- remove 2 sections from worksheet 2
2. Rename worksheet Lista Produse to Lista Produse NAME1
3. At lista produse NAME2 worksheet add the 3 buttons from top row (like in Lista produse NAME1 and add the formulas for discount column (like in Lista produse NAME1)
4. Change the functionality of formular comanda to read products from both Lista produse Tece and Lista produse GROSSMAN
5. Change everywhere the logo NAME1 with NAME2
6. At Worksheet3, we have a section Discount partener. Below add a new section Discount partener NAME2 with 4 items:
At this point , the discounts should be corelated to price list and price offer form , same as for Discount partener NAME1 section
7. At formular comanda worksheet remove discount box (all 5 lines) and on the right remove Valoare cu Discount partener and Extradiscount lines
2. in Worksheet NAME2 (former NAME1):
- add a button LISTA PRODUSE NAME2 below LISTA PRODUSE NAME1
- rename FORMULAR COMANDA NAME1 to FORMULAR COMANDA
- remove 2 sections from worksheet 2
2. Rename worksheet Lista Produse to Lista Produse NAME1
3. At lista produse NAME2 worksheet add the 3 buttons from top row (like in Lista produse NAME1 and add the formulas for discount column (like in Lista produse NAME1)
4. Change the functionality of formular comanda to read products from both Lista produse Tece and Lista produse GROSSMAN
5. Change everywhere the logo NAME1 with NAME2
6. At Worksheet3, we have a section Discount partener. Below add a new section Discount partener NAME2 with 4 items:
At this point , the discounts should be corelated to price list and price offer form , same as for Discount partener NAME1 section
7. At formular comanda worksheet remove discount box (all 5 lines) and on the right remove Valoare cu Discount partener and Extradiscount lines