Wrong customer apprearing

[Veeru]

HI,

I have a code which suppose to go to Pivot table and selet custmer as per range mentioned in other tab "LB_Cust".
I have new custmer called ABC and same hasbeen added to LB_Cut list.
Now pivot is not showing this cusmter and data for new custmer getting into other custmor.

My new Customer showing zero data but when select other customer (which should be zero), showing in this customer.

not sure what is wrong with this code

Attaching sheet with code.

Thanks

[Paul_Hossler]

The attachment only consists of a worksheet with some macro code pasted on it

It's be much more helpful if you could attach a XLSM workbook with the macro and enough data (including the pivot table) that demonstrates the problem

Include a description of the issue with some specific examples please

[p45cal]

Yor attached file contains your code in a few cells,nothing else.
The code looks OK (there are instances when it would trrip up) but not in the way you're stating.
We'd need to see a workbook with these things in. De-sensitise if necessary.
We'd need to see at least:

• The Cal sheet
• The Pivot sheet, with its pivot(s) esp. pivot called PivotTable1
• The sheet holding the source data for the pivot.
• Also point us to where the errant code is.
• You can remove any code which you're sure is irrelevant.

edit post posting: I see Paul's beaten me to it!