N
nytwodees
I have an XLT Excel workbook templete that has 10 tabs at the bottom
for 10 different vendors. These 10 worksheets are purchase order
forms; 1 for each vendor. I would like the following:
1. Whenever I create and complete an order from the workbook template,
I would like the details of the order to update that vendor's XLS
worksheet. By having the XLS worksheets for each vendor, I will be
able to track the quantity of different items I've ordered from each
vendor,
Can anyone advise me how I might accomplish this? Thanks!
for 10 different vendors. These 10 worksheets are purchase order
forms; 1 for each vendor. I would like the following:
1. Whenever I create and complete an order from the workbook template,
I would like the details of the order to update that vendor's XLS
worksheet. By having the XLS worksheets for each vendor, I will be
able to track the quantity of different items I've ordered from each
vendor,
Can anyone advise me how I might accomplish this? Thanks!