I try to record a macro, but have run into a problem: my macro
includes vlookup a pivot table. But the pivot table sheet did not
always come out the same name( in my macro, it is called " sheet2"),
so the vlooup does not know where to look, and returns error. Does
someone know how to solve this problem? Thanks a lot!