Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set up an Ordering facility for a Buying Dept
Would appreciate general guidance/comment for the following
possibility, please: I've been asked if I could set up a facility to 'standardise' the way in which users on a small peer to peer network place their purchase orders......currently each user has developed their own, individual system! If this hasn't been done before, then my initial thoughts are as follows: 1. Create the Master purchase order in an excel sheet. 2. Save the workbook as a Template. 3. One Cell (say "A5") would contain the Primary purchase no. 4. Each time a copy of the sheet is opened, Workbook/Worksheet Change Event code would automatically add '1' to cell "A5". 5. Users would enter job-specific purchase order numbers in "A6" such that a typical entry might be: 00101/ 55321 "A5" "A6" 6. Users would access the Order form via a menu item, and when the Order form is displayed, there would need to be a 'save/ cancel' button. If cancel, then reset the number in the Template. If save, then allow user to browse to a folder of their choice and save, but also save to a default folder (so that a record of all purchase orders is maintained). Is this feasible? Is it already available somewhere? Any help/thoughts much appreciated. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tips for Buying a Laptop & Desktop PC | New Users to Excel | |||
Searching For and Buying Health Insurance in a Bad Economy | Excel Discussion (Misc queries) | |||
Buying Excel Online (Add-ons?) | Excel Discussion (Misc queries) | |||
Find name in list and get dept # enter dept # on work sheet | Excel Worksheet Functions | |||
Countif - Buying Frequency | Excel Worksheet Functions |