dawidb82
12-16-2015, 03:13 PM
Hi, please check my code and fix please. 14995
VBA must work like below.
1. button XML = download XML to sheet "temp"
2. button Update Price = download and unzip specific file ( this is not case for now )
3. sheet "Podsumowanie" column G - must replace in first step "," to "" and second step "." to ","
4. sheet "Podsumowanie" column H - multiply G * E
5. sheet "Podsumowanie" column I - vertical search column C in sheet "CennikPLN" column A and show column L
6. sheet "Podsumowanie" column J - multiply I * E
VBA must work like below.
1. button XML = download XML to sheet "temp"
2. button Update Price = download and unzip specific file ( this is not case for now )
3. sheet "Podsumowanie" column G - must replace in first step "," to "" and second step "." to ","
4. sheet "Podsumowanie" column H - multiply G * E
5. sheet "Podsumowanie" column I - vertical search column C in sheet "CennikPLN" column A and show column L
6. sheet "Podsumowanie" column J - multiply I * E