Results 1 to 5 of 5

Thread: Populate data in form

  1. 01-31-2013, 04:52 PM #1
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0

    Populate data in form

    Hello Good day!
    Anybody want to help.
    I have data that came from other workbook.
    I manually input those data into the form sheet then print it.
    Is it possible to automate this job?
    I will copy and paste the data into "Input sheet" then populate to form in "form Sheet".
    Example:
    Range A2:J2 will populate to form 1 (C4:L4)
    Range A3:J3 will populate to form 2 (C22:L22)
    then automatically add form depends on the number of data in put sheet.

    Thanks in advence
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 01-31-2013, 09:42 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    see if this helps you.
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 02-01-2013, 12:12 AM #3
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0
    Hello Admin.
    Thank you. Unfortunately, i don't know how to use your formula.
    I am still a newbie in excel.
    Thanks
    Reply With Quote Reply With Quote
  4. 02-01-2013, 07:16 AM #4
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    I have illustrated in the attachment how to create name ranges.

    HTH
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  5. 02-01-2013, 10:18 AM #5
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0
    Quote Originally Posted by Admin View Post
    Hi

    I have illustrated in the attachment how to create name ranges.

    HTH
    Thank you so much Admin.
    I have learned new techniques in excel because of this.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Populate Ribbon Controls On Load Dynamically Through VBA Variables
    By phxpoolplayer in forum Excel Ribbon and Add-Ins
    Replies: 1
    Last Post: 04-20-2013, 01:51 AM
  2. Lookup Populate Grouped Information Based On DropDown Selection
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 04-10-2013, 12:40 AM
  3. Best way to cross populate multiple arrays based on data entry into a single array?
    By Orestees in forum Excel Help
    Replies: 14
    Last Post: 01-26-2013, 04:58 AM
  4. INPUT DATA FORM ON WORK SHEET
    By Ryan_Bernal in forum Excel Help
    Replies: 4
    Last Post: 12-30-2012, 05:56 PM
  5. Animation on Form Control
    By Mechanic in forum Excel Help
    Replies: 4
    Last Post: 03-22-2011, 08:56 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
  •  

Forum Rules