Automatically update Data in a Table into Master Data in a separate worksheet

As with most of my queries I am not sure what wording to put in to search engines to check and see if the problem has already been addressed or not! Apologiesi n advance if this has been covered!

I am looking to have a worksheet that a user enters data into a table. The table is fairly generic rows and columns, some dropdown options etc.

What I am looking to do is have a 'master data' worksheet which is separate so the user a) cannot cause issues with formula etc and b) keeps it very simple for the user to manage their data entry.

The idea is that when the user updates information on their data entry table, the table in the master data also gets updated.
I have looked at using an IF statement but I do not know if the user will enter 1 row of information or 1000 rows and I dont particularly want to start having to administer the master data once the user has fininshed. Hope all that makes sense?

The master data set will include the information from the user table plus will have some additional columns to process the preset formula

I have attached a spreadsheet in an attempt to help explain what I am trying to achieve.

MANY thanks in advance for any assistance or guidance provided. Thank you

Ed

A nice empty sheet, nothing in it. Please re-read the yellow banner at the top of the screen, follow its guidelines and amend your sample to show representative data and expected results.

Thank you for your most wonderful comment, very helpful. I trust there is an equal amount of sarcasm in my response.

In case the text description of my original post was not clear, I have updated as you suggest.

Your quantity of sarcasm was just perfect!! Looking at it now..

Still baffled. is it B:H in Masterdata that you want a formula in???

Thank you for your persistence Glenn, no sarcasm this time!

The MASTERdata table will populate as the USERdata table is filled.

B:H in the MASTERdata will replicate what is in the USERdata table.
I:M will contain the formula that is predetermined

Does that help?

Yep. Clear now.

Thank you.

There is something really odd going on with your table!! .. or on my PC. I delete values on USERDATA and they stay there on masterdata.

I have only manually entered everything so far. This is what I need the help with.

I need the MASTERdata table to be the same as the USERdata table (but with the additional columns obivously).

I need the MASTERdata table to populate and also alter if the USERdata table changes.

My current sheet has everything all in one table (like the MASTERdata table example) but the issue is when the user cuts and pastes repeat information then mess up the formulas

I didnt know if there was an easy way to replacate the information? Currnetly I am looking at a button to 'Populate' the MASTERdata and basically wipe the MASTERdata table and repopulate everytime the user presses the button... to run the VBA... I am guessing there is no formula which can do this?

Play with this. Add something to userdata ID . Does Masterdata always update?? There is something odd going on here. Google has not helped me much, yet.

Thank you. I had the same thing but my issue was that this would leave a lot of blank rows in my MASTERdata table, or not enough in some cases? (I appreciate a little administration can overcome the issue, but I was trying to keep it admin easy)

So, I have come up with the attached v3. I know I still have to put my formula back in as I am wiping the whole table when I hit 'PROCESS' but formula back in is fairly straight forward.

I got this far by using the record macro function and cobbling it all together, not ideal but I havent got the time to learn it properly!

Hopefully this shows where I am going with it?