I copy visable subtotal value only to new worksheet. It shown A part no.
Total in one column and qty subtotal in 2nd column. When I open old part no
w/ qty sheet and trying to vlookup the new subtotal by part no. and qty
sheet.

It's not working and show only #N/A. Why? Why can't I use subtotal value
as numberical value data and can be compared with other sheet??

Please help...

BB