Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull information based on a range of numbers
Ok I'm very novice at coding ect. I don't even know if this is possible to do
but I don't see why it wouldn't be. This is my situation. I am trying to make a budget that will pull up predetermend descriptoins/amounts and format a due date based on information stored in another worksheet. But I want to be able to use this inforamtion to pull to multipal small tables. I'll try to Illistrate. Say this is the Database worksheet: Day: Descrption: Amount: 1 Rent 450 13 Credit Card 25 23 Cell Phone 95 26 Car Payment 325 30 Insurance 145 I want it to be pulled to another worksheet based upon a date range.. Say.. I got payed on April 14th. I would want all my bills that I would have to pay that are between April 14th and April 28th to populate in the table. So it would return that I need to pay my Cell Phone and Car Payment and the amounts for both. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a range of numbers in an if statement? | Excel Worksheet Functions | |||
How do i set up a range of numbers which prompts at a particular n | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions |