Automatically insert data into 1 sheet from another sheet

New Contributor

Hello,

 

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!

Capture.PNG

0 Replies