+ Reply to Thread
Results 1 to 2 of 2

Drop down list to change cell value

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    Leeds, England
    MS-Off Ver
    Office 365
    Posts
    2

    Question Drop down list to change cell value

    Hi all,

    I'm making a spreadsheet to calculate cutting sizes for wood panels.

    One sheet has the finished sizes of the material based on the designs and then the other sheet displays the cutting size values based on the data inputted on the finished sizes sheet (these are smaller than finished sizes due to the sides having lamination around them of a few mm).

    For example if cell E,12 on the finished sizes sheet =1000 then it also shows as 1000 on the cutting size sheet.

    I have created a drop down box on the finished sizes sheet which also shows the same selected value on the cut size sheet. This allows the user to select which sides of the panel have lamination, therefore if one edge is laminated (1L) then the cutting size is -2 so 998, however if two edges are laminated (2L) then the cutting size will be -4 so 996.

    What I need help with is writing the formula so that the result of the drop down box automatically changes the cut size accordingly.

    I don't even know where to start with it!

    Thanks!

    EAR = -4L -4W
    1L = -2 L
    2L = -4 L
    1S = -2W
    2S = -4W
    1L 1S = -2L -2W
    1L 2S = -2L -4W
    2L 1S = -4L -2W
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-15-2019
    Location
    Leeds, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Drop down list to change cell value

    Never mind, I figured it out!

+ 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. [SOLVED] Use drop down list to change cell formula
    By IGEDIT in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-2014, 10:39 AM
  2. [SOLVED] How to make drop down list to change formulas in cell?
    By yes man in forum Excel General
    Replies: 15
    Last Post: 11-13-2013, 08:21 PM
  3. [SOLVED] Change a cell based on a drop down list
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2012, 06:25 AM
  4. Drop Down List to change cell
    By Rhys G in forum Excel General
    Replies: 3
    Last Post: 11-01-2009, 08:41 PM
  5. change size of in cell drop down list
    By yep in forum Excel General
    Replies: 3
    Last Post: 01-27-2006, 05:45 PM
  6. Replies: 1
    Last Post: 01-27-2006, 02:10 PM
  7. Creating a drop down list to change decimal value in another cell
    By DoD_au in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 12:05 PM
  8. [SOLVED] How do I change the appearance of an in-cell drop-down list?
    By Nicolai K in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 10:06 AM

Tags for this Thread

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