Linking Information From One Sheet to Another
I am trying to link two sheets together. The user will input information in a new row of Sheet #1 and I want that information to appear in Sheet #2, which has all of the same columns as Sheet #1 and more.
I tried to cell link the sheets together, but I found that I couldn't cell link empty rows together so this solution would require me to retroactively go back and link cells that were recently inputted.
I tried using a VLOOKUP function, but I couldn't seem to select all of Sheet #1 as the lookup table and therefore the solution would not work for new entries.
The third solution I tried was using an automated workflow to copy new rows from Sheet #1 to Sheet #2, but I don't know how I would set the trigger so that it only goes once and if changes are made, it doesn't create a whole new row in Sheet #2.
Does anyone have a solution to this?