That's a fairly major detail to leave out!!
Your specs are now totally confusing. You say "On the report sheet only the last 8 characters will appear". So how is that consistent with "the 5 central digits in column B are checked"? Which has the greater number of characters - the report sheet or the data sheet?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|