Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using VBA to setup calender to determine sales quantity
Hi,
I have a problem with this: I have a worksheet named Sales historical data: Column A: Dates Column B: Phone Description Column C: Sales quantity I need to get the total sales quantity for 5 days. On the left hand side, i want to create a calender in which i can choose the date. then on the right hand side, i want to create another calender in which i can choose the date again. So when i choose a date in both calender like for example, 17 Feb 2010 to 21 Feb 2010, the TOTAL sales quantity for all the 5 days will appear below. Can anyone assist me? If cannot, is there any other alternatives? Thank you!!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using VBA to setup calender to determine sales quantity
One way:
Dates are in Column A values in column C add a combo box to the sheet. In properties select Input Range A:A For link cell I used D2 - you can use a cell behind the combo box. Copy the combo box and set the link cell to D3. The formula to find the sum between the two selected dates is: =SUM(OFFSET(INDIRECT("C"&D2),0,0,D3-D2+1)) In Excel 2003 or earlier choose View, Toolbars, Forms click on the combo box tool and draw it on the screen. The properties form is called automatically. In Excel 2007, choose Developer, Insert Controls and select the Form combo box. Click on the Properties icon in the same group and set the properties as above. HTH - if so click 'Yes' Peter "deadknight89" wrote: Hi, I have a problem with this: I have a worksheet named Sales historical data: Column A: Dates Column B: Phone Description Column C: Sales quantity I need to get the total sales quantity for 5 days. On the left hand side, i want to create a calender in which i can choose the date. then on the right hand side, i want to create another calender in which i can choose the date again. So when i choose a date in both calender like for example, 17 Feb 2010 to 21 Feb 2010, the TOTAL sales quantity for all the 5 days will appear below. Can anyone assist me? If cannot, is there any other alternatives? Thank you!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
Sales Invoicing linked to Sales ledger(Accounts Receivable) | Excel Discussion (Misc queries) | |||
Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
How to determine a quantity that is weight restricted... | New Users to Excel |