+ Reply to Thread
Results 1 to 1 of 1

Create a helper form to fill in Column with several conditions

  1. #1
    Forum Contributor
    Join Date
    12-01-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 365
    Posts
    109

    Create a helper form to fill in Column with several conditions

    Dear All,

    I need help to create a form (by click button in "RGST" Sheet) to fill in column with several conditions (file attached).

    The following conditions are:

    1. ComboBox Date contains unique data from Date column (Sheet PAY).
    2. ComboBox #RCP contains unique data from the RCP column (Sheet PAY) that corresponds to the Date and not yet listed in the # RCP column (RGST Sheet).
    - For Example: If 22 September 2017 selected, it will show the receipt number: 6856,6857,6858,6859,6860,6861,6862,6863,6864,6865,6866,6867,6868,6869,6870,6871,6872,6873,6874 on the ComboBox list.
    3. The Amounts indicate the Total Value of the selected Receipt Number (Payment Sheet).
    4. TextBox is a multicolumn textbox containing unique data from the Unit Name (Sheet RGST) where for the first column is the Unit Name, the second column is Description (filled in "CL" or blank), the third column is the Amount of the "Total" column (Sheet RGST).
    5. As for the data with the description "CL" is the name of the unit that has data in the "Receivables" column which is negative.
    6. The unit name data in the TextBox follows the following conditions:
    - Unique data from the Unit Name that matches the date and data in the # RCP column is still empty.
    - Unique data from Unit Names that have data in the "Receivables" column is 0 or negative.
    - For Unit Names that have negative data in the "Receivables" column, the information is "CL".
    7. More detailed explanation is found on Sheet3.

    I hope my descriptions are clear enough and you understand for what i mean.

    Thank you

    Omega Boost
    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] Fill down dates overwriting times ( vba ) or by adding a helper column with formula
    By Kerryx in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-23-2016, 06:14 AM
  2. Sort by helper column even if values in helper are alike
    By NoSleepForMe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2016, 04:14 AM
  3. Replies: 0
    Last Post: 07-04-2014, 05:37 AM
  4. [SOLVED] Auto Fill-out Form using Drop Down with Conditions
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2012, 03:24 AM
  5. Replies: 3
    Last Post: 04-19-2012, 10:45 AM
  6. [SOLVED] Can I create a fill-in form on excel and then calculate the result
    By Frusterated in forum Excel General
    Replies: 0
    Last Post: 07-06-2006, 04:20 PM
  7. [SOLVED] create a fill-in form using a scanned-in semi-transparent overlay
    By Eric D in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2005, 07:06 PM

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