+ Reply to Thread
Results 1 to 1 of 1

Update excel table from userform

  1. #1
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Update excel table from userform

    HI ,
    I WILL TRY TO EXPLAIN AS CLEARLY AS POSSIBLE WHAT I WANT TO ACHIEVE . YOU WILL ALSO FIND AN ATTACHED SAMPLE FILE BELOW
    I HAVE AN EXCEL TABLE WITH 1000s OF ROWS OF DATA IN IT. THESE DATA ARE ENTERED IN TABLE WITH THE HELP OF A USERFORM BY VBA ADD BUTTON
    THESE DATA ARE NOTHING BUT A SET OF INVOICES DATA BROKEN DOWN INTO ROWS.IN EACH INVOICE I CAN HAVE MAX OF 14 PRODUCTS THAT CAN BE ENTERED AND PRINTED.
    I GENERATE UNIQUE ID BY MERGING VALUES OF CLIENT NAME AND INVOICE NO ...THIS UNIQUE ID WILL SERVE AS MY CRITERIA TO FIND ALL THE PRODUCTS THAT WAS SOLD IN A PARTICULAR INVOICE AND BRING IT TO USERFORM FOR UPDATING. SO FOR EXAMPLE IN "INVOICE 1" HATS , CAPS , COATS, SOCKS AND SHIRT WERE SOLD TO "JACK" THE DATA IS GIVEN IN EXAMPLE SHEET IS ARRANGED BY UNIQUE ID i.e. JACK1 SO A TOTAL OF 5 ROWS OF JACK1 ENTRIES...THESE 5 ROWS I WANT TO GET UPDATED BY ENTERING JACK1 IN CRITERIA AND AFTER MAKING CHANGES I NEED A CODE THAT WILL DETECT THE CHANGES AND UPDATE THESE PRODUCTS , RATES ETC.
    NOTE. THE USERFORM IN EXAMPLE FILE IS FOR REPRESRENTATION PURPOSE ONLY
    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] Update Existing Table with UserForm Values
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-23-2018, 08:29 PM
  2. [SOLVED] userform update table based on 3 criteria
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2016, 04:43 PM
  3. [SOLVED] Userform to Update Table
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2016, 12:15 PM
  4. [SOLVED] Code help: Update new row of Table (ListObject) via UserForm
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2015, 04:11 AM
  5. Replies: 4
    Last Post: 08-15-2014, 04:02 PM
  6. Update excel based on userform text box update
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 01:01 AM
  7. Update table from a userform with controls
    By mohanvp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2011, 03:56 AM

Tags for this Thread

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