+ Reply to Thread
Results 1 to 2 of 2

autofill from a dropdown

  1. #1
    Registered User
    Join Date
    12-01-2012
    Location
    preston
    MS-Off Ver
    Excel 2000
    Posts
    3

    autofill from a dropdown

    hi, i am having a problem anybody help me please? i have down loaded a spread sheet that does what i want but i am having trouble dissecting it and applying it to my project. this is what i need.... sheet1 has my table/list a1 to a10 (ambient temp 25deg,30deg,35deg etc)related to sheet2 cells a5+b5 which are merged as a drop down. sheet1 b1 to b10 with the values (1.04,1,0.91 etc)to enter in sheet2 d5. so what i want is this.... if i select from dropdown eg.. 35degrees i need 0.91 to be entered into sheet2 d5. a little frustrated because i do have an example but as i said i cant figure out how to take it to bits and use it for my needs. if i knew how to post the sheet i would!
    many thanks, dave

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: autofill from a dropdown

    Methinks it's time to upload YOUR workbook. Add some manually calculated results so that we know what answers you expect and some notes which explain, with reference to specific cells how the results are arrived at.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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