Forum Discussion
Gustavo Brunelli
Apr 06, 2018Copper Contributor
Adapt code to work in new file
Hello, I have a issue with a VBA code. I'm trying to use a VBA code from other excel file to my excel file. I think i need to adapte something in the code, but i tried and I did not succeed. When ...
Tomasz Kocur
Apr 09, 2018Brass Contributor
Hi Gustavo
Could you please upload your file as an example?
I understood that macro will work if
1. in the string in the cells in column C contains "C,"
2. value in D1 = "Tech Support"
3. cell value in column D = "PS", "PL", "LS", "P+" etc
4. in cells column F and/or G is not be empty and stirng in cells in column C will not contain the string "+ CC" then it will add to the end of the string
otherwise, it will not work because will have nothing to change in cells value
Could you please upload your file as an example?
I understood that macro will work if
1. in the string in the cells in column C contains "C,"
2. value in D1 = "Tech Support"
3. cell value in column D = "PS", "PL", "LS", "P+" etc
4. in cells column F and/or G is not be empty and stirng in cells in column C will not contain the string "+ CC" then it will add to the end of the string
otherwise, it will not work because will have nothing to change in cells value