I have a PO workbook that has a column for Qty Ordered,Qty received and
Qty Back-Ordered. I need the book to create a copy of it self and
append the file name with a -1 or -2 posibly up to -5 if any of the
material in the backorder column show a Qty.

I would also like the book to update the Qty Ordered column with the
Qty that was backordered when it creates the new book.

Any Ideas?


--
Rich Kniatt
------------------------------------------------------------------------
Rich Kniatt's Profile: http://www.excelforum.com/member.php...o&userid=19093
View this thread: http://www.excelforum.com/showthread...hreadid=530215