Automatically insert data into 1 sheet from another sheet

New Contributor



My work operates using Excel 2016 and I am hoping to have an option to automatically add information to an existing sheet. As attached, I have a sheet where I am updating a bunch of different data which will be tracked for an extended period of time. When I have to add new data, I want to be able to put that information into a separate sheet, and then refresh or have it automatically update into a new row into the existing master sheet.


The reason I want to have this happen rather than just manually insert a new row and type in, is the information is provided in a separate format from how I am tracking in the master, so with this option I could modify to format into the master correctly as well.


Any advice is greatly appreciated!


0 Replies