+ Reply to Thread
Results 1 to 1 of 1

Filter Data Set using Row Headers in lieu of Column Headers

  1. #1
    Registered User
    Join Date
    Fargo, North Dakota
    MS-Off Ver

    Filter Data Set using Row Headers in lieu of Column Headers

    Good Morning,

    I am a Construction Estimator looking to create a historical data base that references previous bid values from our subcontractors so that we can "accurately" make project budgets off of a preliminary set of plans. I know the data points & Layout that I would like to use for my Database, but the problem I am running into is that I am unable to filter my data how I want it to filter. We are looking to filter our data based on a multitude of criteria(Hatched in Red); Project Location, # of Units within the project, What type of building it is, how the garage structures are incorporated, and whether or not they have a clubhouse or not, and possibly a couple more as we develop our processes. This document will be a rolling document for any and all future successful bids so it will get to be pretty large so the ability to filter it by specific items will be very Beneficial. But the problem I am running into is that we can only filter our data by the columns and that column filter only goes throughout the rows within that specific column. where as we would like to filter our data by the rows and have the row filter go throughout the columns with that specific row.

    So for example I would like to go into this Historical Data Base Document and filter all of the projects that are located in Fargo, ND and only see all of the bid data just for the city of Fargo, ND and have it filter out any other city.
    We would also add additional filters to the (Red Hatched area) as we see fit to more accurately fit the project that we are actually bidding.

    Any help on this would be greatly appreciated.

    Historical DataBase Example.PNG
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-03-2016, 02:33 AM
  2. [SOLVED] How to Copy a filter data with headers, excluding the headers?
    By Elomaldo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2014, 03:35 PM
  3. [SOLVED] listbox with column headers as a specific sheet column headers
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2014, 04:40 AM
  4. Replies: 4
    Last Post: 02-08-2014, 02:31 PM
  5. Replies: 2
    Last Post: 05-09-2012, 01:30 PM
  6. Replies: 3
    Last Post: 09-30-2010, 12:30 PM

Tags for this Thread


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