copy subtotal value only - also can be lookup from other worksheet

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

Nel post news:[email protected]
*BB* ha scritto:

> 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

Post some example, or upload an example file to www.savefile.com


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy