+ Reply to Thread
Results 1 to 1 of 1

replicate regions drop down list

  1. #1
    Registered User
    Join Date
    02-15-2011
    Location
    Carberry, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    replicate regions drop down list

    Hello. This is my first post on the forum. I looked around a bit, but the amount of information and traversing it is a bit overwhelming.

    I am not any kind of advanced user. I use 2003 on Vista.

    I'd like to generate a button on a worksheet that inserts "Units" from a different sheet. This "Unit" is a region of cells that contain multiple formulas with absolute and regular references. Ideally there would be a Select From List that listed all the different Units.

    I explain it a bit better below.

    I am trying to build a calculator for determining pricing for cabinetry. On the attached Workbook you will see three sheets. The first two are duplicates, just for ease of use. The third has master general information that is referenced by the Units on the other sheets. You will see some common items (the Units) on the Unit Copies sheet. What I need to do is find a way of generating a report where I add multiples of these items as required and fill in each one individually. I am assuming that there is a very easy way to do this and that it is just not quite average user stuff.

    Maybe I'm wrong in that assumption.

    Nevertheless, thanks for reading at least.

    Jerrold
    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)

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