+ Reply to Thread
Results 1 to 2 of 2

Vba - read data from sheet1 in form & should store in sheet2

  1. #1
    Registered User
    Join Date
    10-06-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    32

    Question Vba - read data from sheet1 in form & should store in sheet2

    Dear All,

    Please help me for the below, as i am new to the VBA programming,

    My question is, i have sheet1 sheet1.png (image attached) where some datas are stored(roll_Number, name, class, fees_amount) that should be displayed in Form1 entry-form.png (image attached) which i have created. If i enter the roll number in text box in my form the name and other details should be displayed in respective labels.

    After display correct student data, i will add feed paid in textbox2 and select fees month from combo box1.

    Finillay all the values should be stored in sheet2 sheet2.png (image attached) without over writing

    date should be taken from system and stored in sheet2

    many many thanks in advance....!

    Regards,
    Cool Sab
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Vba - read data from sheet1 in form & should store in sheet2

    Please do not post requirements to the forum and wait for a free solution.



    Go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
    And read the FAQ on how to solicit paid help.

    If you have tried to solve the problem, then post a workbook and specify what you tried that did not work,
    Ben Van Johnson

+ 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 show value form sheet1 b2 in sheet2 c2
    By sspreyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2014, 08:30 AM
  2. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  3. [SOLVED] match data form sheet1 and sheet2 and extract it out
    By mathanraj76 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-25-2013, 10:42 AM
  4. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  5. Replies: 1
    Last Post: 08-27-2012, 07:13 AM
  6. Read Sheet1!A:A then mark corresponding cells in Sheet2
    By ashleysandell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2011, 07:06 AM
  7. Replies: 3
    Last Post: 01-13-2005, 12:05 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