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.

SRenner

@Andrée Starå @Paul Newcome Thanks for the help guys. This is the formula I came up with to make it work I think. It is bringing over the values I am looking for.

=MAX(COLLECT({8 - Texas Shuttle Tracker Dispatch Board Range 1}, {8 - Texas Shuttle Tracker Dispatch Board Range 2}, "TEXAS SHUTTLE")

This is the first time working with the MAX and COLLECT functions. I am going to have to get to know this better, makes it much easier.

Thanks again!

Scott

Andrée Starå

Hi Scott,

Unfortunately, it's not possible at the moment to have the row added to the top, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.

Andrée Starå

@Paul Newcome Good idea! 👍️

SRenner

Thanks Ill try that and let you know!

Paul Newcome

@Andrée Starå Thanks! 👍️

@SRenner Sure thing. We can help with the formula(s) as well if needed.

SRenner

@Andrée Starå @Paul Newcome Thanks for the help guys. This is the formula I came up with to make it work I think. It is bringing over the values I am looking for.

=MAX(COLLECT({8 - Texas Shuttle Tracker Dispatch Board Range 1}, {8 - Texas Shuttle Tracker Dispatch Board Range 2}, "TEXAS SHUTTLE")

This is the first time working with the MAX and COLLECT functions. I am going to have to get to know this better, makes it much easier.

Thanks again!

Scott

Paul Newcome

Glad you were able to get it working! Happy to help. 👍️

The COLLECT function definitely brings a lot of flexibility to a lot of other functions.

Please don't forget to flag the most appropriate response(s) as "accepted" so that others searching for a similar solution can know that one may be found here.

@Andrée Starå

I had this sent to me by someone, and I think it may be appropriate here...

Andrée Starå

@SRenner Excellent! Happy to help and glad you got it working!

Andrée Starå

@Paul Newcome Haha! Good one!

🤣