Formatting for Pivot Table use

[jomili]

On my "Steps" sheet I have a cell (B2) that has a value such as "02CPS". I have a pivot table (not one I created; it already exists in the workbook, and it's the one I have to use)which has as a Department "020", which means "02CPS". I have a macro which I want to select the "020" in the dropdown for DeptID, based on the value in cell A1.

How do I tell my macro that 02CPS equals 020, and retain that value to select in my dropdown? I tried using the below code to convert B2 and paste it into C1.

Please Login or Register  to view this content.

However, it pasted "02CPS" instead of converting it to "020". I'd appreciate any help getting that part right.

For my second part, once I get the correct valued in C1, how do I use it to select my Department? I've put in this line, but can't test it yet, so don't know if it will work:

Please Login or Register  to view this content.

Any help is greatly appreciated.