Results 1 to 9 of 9

Automate the Build of a Design Matrix in MS Excel

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2014
    Posts
    10

    Post Automate the Build of a Design Matrix in MS Excel

    A typical Design Matrix is shown in the attached Workbook. There are two domains of Merged Cells that make up the Headings of the Matrix; FRs (Functional Requirements) and DPs (Design Parameters). Given a Hierarchical List of FRs specified by the User, the User would like Excel to bulild the Matrix Hierarchy of FRs automatically (going down the Worksheet). The DP Hierarchy is the same hierarchy, except transposed and reflected across the Worksheet. The attached Workbook has up to seven (7) levels, but the ability to go create up to 10 levels is desired.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining buttons and VBA to build matrix
    By hamudenben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2012, 02:03 PM
  2. build distance matrix
    By bogdanp in forum Excel General
    Replies: 1
    Last Post: 10-08-2009, 03:29 AM
  3. Excel 2007 : build a 2 by 12 matrix excel 2007
    By littlerockz in forum Excel General
    Replies: 2
    Last Post: 03-23-2009, 10:54 AM
  4. Matrix Build from 3 Columns of Data
    By shartrich in forum Excel General
    Replies: 4
    Last Post: 12-01-2008, 12:31 PM
  5. [SOLVED] How can i build up a Matrix in EXCEl ?
    By Mischa Sollberger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2006, 08:35 PM

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