Copying rows into another sheet, can you use automation to place a copied row into a specific row?
Best Answer
-
I would rather use INDEX/MATCH to populate the data into the second sheet based on the Number. Here the number will act as the unique identifier. Here's how the formula works
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz Software, Exton, PA
https://www.linkedin.com/in/amitinddr/
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"
Answers
-
I would rather use INDEX/MATCH to populate the data into the second sheet based on the Number. Here the number will act as the unique identifier. Here's how the formula works
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz Software, Exton, PA
https://www.linkedin.com/in/amitinddr/
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"
-
Amit, thank you very much. It works as it should!