+ Reply to Thread
Results 1 to 12 of 12

copy data from userform to specific sheet based on match sheet name with label name

  1. #1
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    copy data from userform to specific sheet based on match sheet name with label name

    Hello
    I want copy data from userform to specific sheet when I select optionbutton3(case1) will rename label3 based on sheet name and select optionbutton1 and combobox1 and fill textbox 1, then should copy to specific sheet with match sheet name for label3 .
    just I want copy data from userform to specific sheet after matched with sheet name for label3 when select one of two optionbuttons3,4(cas1 or case2)
    to understand how works the others tools when select one of two optionbuttons1,2 and fill combobox and textbox will copy to sheet start from column B with different column for amount where filled in textbox based on selected optionbuttons1 or 2 .
    thanks
    Attached Files Attached Files
    Last edited by Alaa-A; 10-20-2022 at 03:16 AM.

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Why if "PAID" it is a debit and not a credit...And why not individual for each person...All on same sheets?...Then how do balances work...I think you need to go back to the drawing board...
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Hi sintek
    I edited file
    about PAID you're right and I put two formulas for each name how should be first row and how should be next row for each name with considering when there is the same name in sheet is matched with combobox should put under which is relating of the name . this mean all of data for the same name should be under each other of them .
    so when select optionbutton3(case1) or optionbutton4(case2) will rename label3 is matched with sheet name and when fill textbox1,select name from combobox1 and select optionbutton1(notpaid) ,then should copy to sheet name based on label3
    last thing when select optionbutton1 should copy amount from textbox1 to column D and optionbutton2 should copy amount from textbox1 to column E and I put the formula in column F . as to name should copy from combobox1 to colum B ad optionbuttons 1,2 names should copy to column C .
    I hope this help .

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: copy data from userform to specific sheet based on match sheet name with label name

    thanks sintek
    about name I want putting all of data for the same name under of each other like I put from column L:Q
    when I select name from combobox ,then will search for the name in sheet if it's existed should copy data under the same name if it's matched with combobox1 . and put serial number in column ITEM sorry I forgot putting in OP .
    Attached Files Attached Files

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Try.......
    Attached Files Attached Files
    Last edited by Sintek; 10-20-2022 at 06:50 AM.

  7. #7
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: copy data from userform to specific sheet based on match sheet name with label name

    thanks again !
    the last entering on userform for the same name should start from under last row for the same name is existed in sheet
    as you see when entering data for the same name will start from row 2 for the same name as highlighted in red from A: F if I have already name in sheet but the right way should start after last row is existed for the same name , in this case should be from row4 as in column L:Q to see th final balance the name in row4 =466 but your code show the final balance in row 2=466 this is error!
    Attached Files Attached Files

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Now I understand...see amended Post 6 file

  9. #9
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: copy data from userform to specific sheet based on match sheet name with label name

    ok . just show problem about color formatting when copy data from userform from the first time when there are no data in two sheets .
    it will highlight yellow color for entered data from userform to sheet as in headers . shouldn't do that .

  10. #10
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    see post 6 file...

  11. #11
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    312

    Re: copy data from userform to specific sheet based on match sheet name with label name

    all of things are really great !
    thanks for your time and solution

  12. #12
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: copy data from userform to specific sheet based on match sheet name with label name

    Glad to have helped...Tx for rep +

+ 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] copy data from userform to specific sheet(month) based on date into lable
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-23-2022, 11:24 PM
  2. Extract data from sheet based on specific match
    By tamiwsw09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2021, 09:34 PM
  3. Replies: 0
    Last Post: 09-16-2015, 01:18 PM
  4. Replies: 11
    Last Post: 01-20-2015, 09:34 AM
  5. [SOLVED] Macro to copy date to specific sheet based on data from another sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-09-2013, 11:28 AM
  6. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  7. [SOLVED] Copy userform data to a second sheet based on ComboBox value?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-08-2012, 09:09 PM

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