+ Reply to Thread
Results 1 to 1 of 1

Populate cells from value in other cell

  1. #1
    Registered User
    Join Date
    Rotterdam, Netherlands
    MS-Off Ver
    Office 2016

    Question Populate cells from value in other cell

    Dear Forum,

    I am struggling with a Form I want to generate.

    A part of it is already cleared (UserForm and making tables/named ranges/layout of the form).

    But the part I can't seem to figure out is as described below:
    In Cell "C11" on Sheet "Form" a product will be selected (To stay with the tradition, I used Fruits and Vegetables to simplify), and based on this selection, a series of predefined checks will be selected.
    Example: If the selected "Group" is Fruits, and the selected "Product" is "Apple" Checks 1,2,3,4,5,6 are applicable. Selections and the related checks are defined on the Sheet "Products", and the checks that belong to each product are defined on the Sheet "Data".
    The checks have a number 1-6 (Data!"F:F") to have an easy overview. The explanation of the checks are in the column next to it (Data!"G:G"), and the expected results of these checks next to that (Data!"H:H").

    The related checks and results from columns G and H should be copied to the Sheet "Form" from Cell "C15" down (2 columns - C15 & H15) to have a correct lineout.
    Different selections have different checks, so it all needs to be dynamic.

    A simplified example is attached. I removed the userform selection boxes, since that part is already figured out.

    This form is used for quite a bit more groups/products, but should be OK with VBA.
    If anyone can help me with this, or has a good suggestion, I would be very happy.

    brgds, Kevin
    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)

Similar Threads

  1. [SOLVED] populate cells with the same value as the cell above (same column)
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2017, 02:16 PM
  2. [SOLVED] Looking to populate cells based on another cell
    By Bahal_tb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-22-2017, 12:14 AM
  3. Replies: 6
    Last Post: 05-16-2014, 03:03 PM
  4. Populate cell with another cells data.. Please Help!
    By trollema in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2013, 09:18 PM
  5. how to populate certain number of cells from the value available in another cell.
    By ronniephilip in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2013, 12:51 AM
  6. Populate cell with letters from other cells
    By ERudy in forum Excel General
    Replies: 3
    Last Post: 05-16-2006, 12:15 PM

Tags for this Thread


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