+ Reply to Thread
Results 1 to 4 of 4

Form population from tab

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2019
    Posts
    26

    Form population from tab

    We have two tabs

    Tab 1 is a form and is pulling information from row 2 to populate the form. The form has a lot of formulas that are applied and I am not adding those to the attached example.

    Tab 2 is a list of loans (a workflow of sort) with information that needs to populate the form on tab 1. We work the loan on row 2 and then once we are done we delete the loan and row 3 becomes row 2.


    We need the loan that was on row 3 and is now row 2 to populate the form on tab 1.

    We are getting a ref error after we delete row 2.

    I attached a sample of what part of the form looks like.

    Is this making any sense?
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Form population from tab

    Try this in B1
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    B2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    B3
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2019
    Posts
    26

    Re: Form population from tab

    Thank works!!! Thank you very much!

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Form population from tab

    Happy to help

    BSB

+ 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. How to stop and confirm auto population fields in user form based on one value
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2018, 05:03 AM
  2. [SOLVED] Tab order & form population question -workbook included-
    By diskin8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2017, 08:56 AM
  3. Auto population on a form
    By twiglett811 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-05-2014, 05:51 AM
  4. Population Pyramid
    By bobisnotkee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2013, 11:28 PM
  5. Replies: 0
    Last Post: 07-10-2012, 08:37 AM
  6. Population of 1's and 0's
    By zuehlkescott5 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-04-2011, 01:24 PM
  7. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 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