Copying a row from one sheet to the other

SRenner

Hello,

I am trying to copy a row from one sheet to another through automation. When a date or a run name is entered into a row, it will send that row to a data sheet I created. From that data sheet, i have a third sheet that uses vlookup to pull the dates and run name over to a calendar based sheet.

My issue is that when i copy the row over, it always puts it at the bottom of the page. I want it to be added to the top of the page like a form can do.

or if cannot get the copy row to go to the top of the page, i need the Vlookup formula to read duplicates from the bottom of the page up instead of top down.

any suggestions?

thanks

Scott

Paul Newcome

Instead of a VLOOKUP, you can add to the sheet you are searching a Created (date) column then use a JOIN/COLLECT/MAX combo to pull the most recent row.