Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Styckz
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use a range of numbers in an if statement? pbeattie Excel Worksheet Functions 2 October 10th 05 10:36 PM
How do i set up a range of numbers which prompts at a particular n Stefan Excel Discussion (Misc queries) 0 October 10th 05 11:29 AM
Count comma separated numbers, numbers in a range with dash, not t Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM
How can I assign a range starting cell based on a variable locati. feman007 Excel Discussion (Misc queries) 1 March 9th 05 11:41 PM
How can I assign a range starting cell based on a variable locati. feman007 Excel Worksheet Functions 3 March 9th 05 11:40 PM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"