Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Saving a workbook as -1 under certain criteria


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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Saving a workbook as -1 under certain criteria


TTT any Ideas

--
Rich Kniat
-----------------------------------------------------------------------
Rich Kniatt's Profile: http://www.excelforum.com/member.php...fo&userid=1909
View this thread: http://www.excelforum.com/showthread.php?threadid=53021

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook Don Excel Discussion (Misc queries) 0 April 20th 08 04:51 AM
Saving sort criteria thouston Excel Discussion (Misc queries) 0 November 7th 07 02:56 PM
Saving Sort Criteria Wendy Ann Excel Discussion (Misc queries) 0 September 23rd 06 08:49 PM
Saving a sheet in a workbook as .csv but not changing workbook name gloryofbach[_4_] Excel Programming 3 October 30th 05 08:50 PM
Saving a Workbook: Forcing User to Rename before Saving Rollin_Again[_6_] Excel Programming 5 April 16th 04 02:54 PM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"