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

[Guest]

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

 

[Franz Verga]

Nel post *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