Ask Experts Questions for FREE Help !
Ask
    ksfrance23's Avatar
    ksfrance23 Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Jan 9, 2012, 03:08 PM
    Extracting values from different worksheets based on a date range
    Hello,
    I need to create a worksheet called "Current Rent Roll" that is linked to individual lease worksheets within the same workbook. The new worksheet needs to pull a value from a range in the other worksheet based on the date in another range of that same worksheet. In other words, Current Rent Roll would pull the lease amount from each worksheet based on the date (Februay 1 - 29, 2012).
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jan 10, 2012, 10:48 AM
    I would need to see a sample workbook with a fully mocked up ROLL SHEET showing your full desired results, and a few "individual lease worksheets" from which those sample results were derived.

    Mock that up (replace sensitive info with something generic for the sample) and post here.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

My due date is Dec 3 and based on that my conception date is March 12. [ 3 Answers ]

My due date is Dec 3 and based on that my conception date is March 12. I had sex on Feb 26 and again on March 12. I need to know which of these dates could be the correct date I got pregnant. I am confused because I had my LMP on March 7 to March 11 which was a light(spotting)period which I am use...

Comparing Date Values in VBA [ 3 Answers ]

Jerry, you'll probably be the one to respond so I'll just post this for you. I'm trying to compare some date values using VBA and the issue I'm having is that my code is treating date values that are older than more recent values as greater. So, if you were to run the code below you'd see that...

To-date total based on current date [ 1 Answers ]

:confused: I am trying to create a forumula that will give a cumulative or "to-date" total that will exclude future months from the total. i.e. ithe point in time is August and I need to show a to-date number Through August only even though September and October are included in The...

View more questions Search