Update data between two tables using userform vba

[jdasp49]

Hi Everyone,
I will be very thankful if you kindly help me the Excel vba which I have attached below.
I have sent a form and some codes which I have copied from some other source.
It will be thankful if you could kindly modify it for me.
The goal is, any changes made in userform1, by "update Command",
and through userform2, the change must be reflected in table1-Fruits and table2-Orange
Some of the important conditions are:
1.Selecting combobox1(choose month) should display on listbox1 all data of that month.
2.Selecting a row, for example orange, on listbox1, and choosing "Update" command,
will be open a second userform(2) to change data.
3.With save command, the changing of data, must be automatic and should reflect in both tables,
on table1-Fruits and table2-Orange simultaneously .
Thank you in advance

[torachan]

I am trying to understand your two tables.
Why are the left column numbers in 'Fruits' transferred to the right column in 'Oranges' and the right column numbers in 'Fruits' transferred to the left column in 'Oranges' ?
torachan.

[jdasp49]

Hi Torachan,
Thanks for the quick response
I do not know if it will make any sense, but it is to make the correspondence between them, which perhaps facilitates the vba code.
In Table1, the first column corresponds to the order of entry, of the records of different types of fruit, and in Table2 it corresponds to a subtable of the specific fruit -Orange.

[jdasp49]

hi
I have not Power Query
If you could offer any solutions, I would really appreciate it.
Thank you

[torachan]

Give the attached a try.
If you want to add a different fruit/item, first name a sheet tab, then add it to the master list (Fruits), ensure the spelling is identical.
Open the form and you should see your new item in the combobox list, select it, then selected it from the listbox, alter the textboxes if you need to, press 'Update'.
You now have a new table in your new sheet, the only sheet that actually updates is the master(Fruits), then the updated data is copied back as a complete table to the individual sheets.
When adding to the master ensure first column contains row number - the search and updating uses this as a reference.
Please note all the primary data is taken from the master list - there are no hard coded items required to fill the combobox it is all filtered from your actual data.
Any queries post back on this site.
torachan.

[jdasp49]

Hi ToraChan,
Very interesting indeed!
Many Thanks for your disponibility of help.
I will go to reflet to your project as to its functioning and as to the possible adjustment to my example test, and in any case if I have any doubts, I will take the liberty, if I allow it, to ask a clarify any doubts.
Again my sincere thanks
Solved