Results 1 to 3 of 3

Thread: Putting a value in the inidcated cell without a formula in each possible destination

  1. #1
    Acolyte GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    24
    Articles
    0
    Excel Version
    365

    Putting a value in the inidcated cell without a formula in each possible destination



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I don't have much experience in VBA so I'm not sure if what I'm asking is possible.

    I have a large range of cells with various dates across the top (not consecutive but in ascending order)
    I have user entered cells down the side where they enter a date and a value.

    I'd like to put the value in the corresponding date column that either matches it (or if no match the next highest date).

    I could put a formula into each cell in the grid but that would consume a lot of calculating power and create a boggy spreadsheet.

    Is there a VBA sequence that could evaluate the user entered date and put the correct value into the correct column along that row?

    I've included an example file (without formulas) that hopefully illustrates what I'm trying to do

    the first tab "Pull" shows the traditional multi formula method which shows how quickly calculation power can be used up. The input areas are in yellow
    the second ""Put" tab illustrates how I want to enter into the yellow area and then have VBA place the correct value in the corresponding column.
    Attached Files Attached Files
    Last edited by p45cal; 2020-09-26 at 12:34 AM. Reason: merged 2 posts

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,785
    Articles
    0
    Excel Version
    365
    Try the attached.
    Attached Files Attached Files

  3. #3
    Acolyte GTretick's Avatar
    Join Date
    Jul 2015
    Location
    Canada
    Posts
    24
    Articles
    0
    Excel Version
    365
    That worked perfectly.

    Thank you!!

    I will now try to take this model and apply it to a larger spreadsheet. Hopefully I can change the correct variables to keep it working.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •