Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving monthly information from order form
Thank you in advance for any assistance you can provide. I am still
trying to learn excel and am struggling. I have an order form for supplies that is updated monthly for various facilities. I want to store the information from each order onto separate sheets, according to facility and month. The order form is set up like this: Facilty Name Date of Order Product ID Product Name Quanity Wanted Unit Price Total I want the Quantity Wanted, Unit Price, and Total transferred to a worksheet for the corresponding facility. Each facility sheet has a list of the products. I was planning on having the months across the top row. I have spent many hours trying to do this using conditional information about facility and date and then using lookup tables to get the information regarding quanity and price. It worked for January - then as soon as I change the date, the information in January disappeared. I hope this makes sense. Any help would be appreciated. I also tried writing code for it using a command button to update the month. I didn't have much luck with that. Thank you in advance for any help. Carolyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPYING AND SAVING THE INFORMATION | Excel Discussion (Misc queries) | |||
monthly capturing of information | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
Saving a monthly report using Visual Basic | Excel Discussion (Misc queries) | |||
Displaying YTD totals as you populate monthly information | Excel Worksheet Functions |