Copying a row from one sheet to the other


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?



Best Answers