Hi,guys!
I have a pivot table like:
| | | Month | Jan-15 | Jan-15 | Feb-15 | Feb-15 | Mar-15 | Mar-15 |
| Business Group | Employee | Main skill | Bench Salary | Bench FTE | Bench Salary | Bench FTE | Bench Salary | Bench FTE |
| International Other | Name 1 | .NET | 10000 | 1 | 10000 | 1 | 10000 | 1 |
| International Other | Name 2 | .NET | 8000 | 0.8 | 10000 | 1 | 10000 | 1 |
| International Other | Name 3 | .NET | 550 | 0.55 | - | - | - | - |
There are values in Bench Salary that can be eiher in USD or UAH. I want to create an InputBox where I'll write currency rates so the UAH values in the 'Bench Salary' field will be converted to USD. Any suggestions how to do that?
