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
Bookmarks