Results 1 to 7 of 7

Extract data based upon Yes/No condition

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    12

    Extract data based upon Yes/No condition

    Good afternoon everyone. I'm preparing a budget for an office building for 2013. I think my problem is fairly simple but I'm stumped (see attached).

    I have a spreadsheet which contains a current rent roll for a property. I've inserted a Yes/No data validation in column U of the Rent Roll tab, which is intended to identify whether the tenant is projected to renew its lease (assuming the lease expires sometime during 2013). Ideally, the data validation would not be able to be changed unless the year that the lease expires (column I) equals 2013, but I've not figured out how to do that yet.

    My goal is to extract the tenant name, Suite number, & Sq Ft from the Rent Roll tab onto the 2013 Renewal tab if the answer in column U from Rent Roll tab = Yes for each tenant. The 2013 Renewal tab has several sections for such tenant info, some of which will be blank depending on how many tenants are expected to renew their leases. For the moment, I've just linked the data I'm trying to pull on the 2013 Renewals tab and have highlighted the fields I want to insert in yellow.

    I really, really appreciate your help in advance!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1