+ Reply to Thread
Results 1 to 9 of 9

Autofill data with value where row and column intersect after user enters data

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    7
    Posts
    41

    Autofill data with value where row and column intersect after user enters data

    Hello,

    Need some assistance with attached worksheet.
    At the top of the worksheet we have (3) main boxes "Miles", "Weight", and "LN charge".
    We need the "LN charge" box to autofill with value of where Miles & Weight intersect after user enters data in the "miles" & "weight" boxes

    We also need this to be in VBA macro

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Autofill data with value where row and column intersect after user enters data

    What would be the expected result in the LN Charge box if Miles=182 and Weight=1993? The way that the weight section of the sheet is organized doesn't seem to follow any pattern. Am I missing something?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Autofill data with value where row and column intersect after user enters data

    Hi trubio,

    Place this in the worksheet1 module and see if it works for you:

    Please Login or Register  to view this content.
    @Mumps... I suspect the example is not a good one since the weight in the sample exceeds the current table setup.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Autofill data with value where row and column intersect after user enters data

    I sure did miss something. @Arkadi: Thanks for the post. Your code made everything very clear.

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Autofill data with value where row and column intersect after user enters data

    Try this,

    Please Login or Register  to view this content.
    Ah---somebody has replied already.

  6. #6
    Registered User
    Join Date
    10-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    7
    Posts
    41

    Re: Autofill data with value where row and column intersect after user enters data

    sorry about that

    miles 182 / weight 1204 which they intersect at 1850 (17F)

  7. #7
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Autofill data with value where row and column intersect after user enters data

    @trubio77

    My code gives that result. (davesexcel's probably too... I just didn't test that one)

  8. #8
    Registered User
    Join Date
    10-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    7
    Posts
    41

    Re: Autofill data with value where row and column intersect after user enters data

    davesexcel,
    this worked except that it does not autofill - I have to go into view code and hit the green run sub button
    do you have a fix for this

    thank you

  9. #9
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Autofill data with value where row and column intersect after user enters data

    Please Login or Register  to view this content.

+ 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: 0
    Last Post: 02-10-2016, 09:37 PM
  2. lock cell and/or message box after user enters data?
    By ashtally in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 04:56 AM
  3. Macro to search row and column for intersect and then input a data to where they meet
    By aloconnor in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-10-2014, 04:21 PM
  4. Replies: 5
    Last Post: 06-22-2014, 08:27 PM
  5. Autofill based on User selection - two data sets
    By grammydaisy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2014, 02:54 PM
  6. Replies: 0
    Last Post: 10-30-2012, 03:48 PM
  7. Replies: 2
    Last Post: 12-31-2011, 02:44 AM

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