Transfer Names to List and Sort A-Z

[catnam]

In the attached workbook, you can click the "Add a Name" button to open form. Once a list (INCOME, EXPENSE, or MISC) is selected in the combobox, up to 3 names can be entered in the textboxes. Then by clicking TRANSFER the names are transfered and added to the list in columns A (INCOME), B (EXPENSE), or C (MISC).

Currently everything works fine, but instead of the names being pasted into columns A, B, or C, I wish for them to be pasted into column D, F, and H, starting at row 10 or the next available row. I have the column headers in D8, F8 and H8, with row 9 blank. However, headers can be place in row 9, if necessary.

Finally, once the names are pasted to the selected list, I want the list to AutoSort, A to Z.

Thanks in Advance for Your help

[protonLeah]

Please Login or Register  to view this content.

Named ranges used:
Expense =Sheet2!$F$8
Income =Sheet2!$D$8
Misc =Sheet2!$H$8

[catnam]

Thanks Ben for the code.
I've placed it into my form code. See new workbook attached.

However, for some reason there is an error at this line of code:
NextListItemRow = Cells(Rows.Count, Range(ListText).Column).End(xlUp).Row

Also,I see a SortRng1 and SortRng2, if these refer to two of my lists, should there also be a SortRng3?

[kvsrinivasamurthy]

Here is the code

Please Login or Register  to view this content.

[catnam]

Thanks kvsrinivasamurthy,

Here is the workbook I'm trying to put your code into.
The code is in the form module
I wish to have the names that are entered into the form textboxes, copied, pasted and sort on the NAMEMANAGER sheet.
Pasted and sorted in D10:D200 for INCOME, F10:F200 for EXPENSE, and H10:H200 for MISC

*** To return menu bars, minimize the workbook first by click hash/dash in upper right corner, then maximinze.

Thanks

[kvsrinivasamurthy]

Code edited. It is working now ok.
You referring to sheet as sheet33. It is not a good practice. It will be very difficult to edit or view working.
Instead it is good to refer the same sheet as Sheets("NAMEMANAGER")

[catnam]

Thanks again and I do appreciate your patience.
The code does indeed work, but only if the "Open EditName Form” button, that you added, is on the NAMEMANAGER sheet. I would like for this button to be on each budget sheet.
Currently, if I click existing “Name Manager” button, on any budget, the same EditName form opens; or if I copy your “Open EditName Form” button to JAN budget and click it the same EditName form opens. However, in both cases sorting does not take place correctly, as it does when I click the “Open EditName Form” button, on the NAMEMANAGER sheet.
If you can, please make “Open EditName Form” button (or existing Name Manage buttons on budgets) work from JAN and other budgets. If possible, just add to JAN and I will copy paste it to the other budgets.
Thanks so much.

[kvsrinivasamurthy]

Code revised.
I have put button in Jan sheet. Working ok. Similarly copy button to all required sheets

[catnam]

The code seems to work.

Thanks

Catnam

[kvsrinivasamurthy]

Code was not working for NAMEMANAGER sheet. I modified code. It works for all sheets

[catnam]

Thanks for the fix, but the code is very tempermental.

I noticed you added module 45 with Sub OpenFormEditName code, to open the form.
This always work in my larger file.

Also I see the added code (in cmdTransfer button) in the form module, which I suppose is to copy, paste and sort the names on NAMEMANAGER sheet.

However, whenever I create a module 45 in my larger file, add a shape to JAN, then link module 45 code to said shape, then change the appropriate sheet name to NAMEMANAGER, then copy the form and cmdTransfer button code to larger file, wiht no changes except sheet name, it does not work. It goes through all the motions, without any error messages, but nothing appears on the NAMEMANAGER sheet. I've checked the spelling of the name multiple times, at each place it appear in the code.

Did you add code to any other modules?

[kvsrinivasamurthy]

Module 45 for opening the userform is added. Userform code edited as per your requirement. I haven’t added or changed any code.