like this, i have a work book included 4 sheet.
1 is pivote report
2 is stock list
3 is supplier contact
4 is reorder page

the supplier list have 25 supplier (have contact numbers, fax numbers,
address)
the stock list have 1400 items.(can auto filter by stock type, supplier and
stock code)
the problems is, i hope this file can print out the items order at the stock
list (FILTER BY NO BLANK) by supplier contact on the header. footer will be
the buyer company name.
is that any one can help with this issue?
how can i make it post all the items reorder to the orderform? i can set the
orderform display out the supplier contact num and fax num address and etc by
vlookup when i enter the supplier numbers in supplier list.