Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help with Excel and VB!
Every week, I am given a new purchase order (PO) number from my accounting department which I must reference when doing my orders. (e.g. PO # 200, 300, 400, 500, 600, etc.) If I'm given a PO number, then I am expected to use that number as my starting point. (e.g. Told to use PO Number 200, thus Order 1 = 200, Order 2 = 201, Order 3 = 202, etc.) I have 12 orders I have to do for work on a weekly basis. Sometimes, I am doing all 12 orders, and other times I am doing only 3 or 5 orders. Thus, to reduce confusion, I have created an easy order sheet with checkboxes next to the Order Company. What I would like to do is assign a cell (like cell E1) with the starting PO number that I am given, and then when I click on a checkbox for an order, that PO number will appear at another assigned cell. Subsequently, if I check another checkbox, then I would like another cell to give me the following/next value. Does anyone have any suggestions or VB scripts that might help. I'm not that good at VB. Thanks! *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setup Purchase Order Template to have a automatic number system? | Excel Worksheet Functions | |||
Increment Purchase Order Number | Excel Programming | |||
Purchase order... | Excel Worksheet Functions | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel |