Updating a dynamic list

[Coveythebum]

Hi! I am looking to learn if it is possible to update a growing list within excel through a separate sheets inputted values. I will use name, height, weight, and age as example placeholders.

On the first sheet (Sheet1), I would like to have inputs for the above data which will then populate a second sheet (Sheet2) in the next available rows and in the correct columns for that data. That way my team can input new users manually in Sheet1 which will then grow a locked list separately over time in Sheet2.

Please let me know if any of this is unclear. Happy to explain in better detail! Thanks so much in advance!

 

[My Aswer Is This]

Sure this can be done using Vba. But we always need specific details.
Like both sheet names
Where on sheet Master will you enter these values like:
Where will you enter:

name, height, weight, and age as example placeholders.​

We need specific locations. Not just sheet names.
And where on the other sheet will these values need to be entered.

Like in what column does Name go in what column does height go in.