Copying a few rows from a column from 1 sheet to another?

shubhangia

How do I copy only a few rows from a column in an IF formula, I am able to copy only 1 row at a time?

Andrée Starå

Hi @shubhangia

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy/move the row from that sheet to the main destination sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

shubhangia

Hi Andrée Starå,

Thank you for the reply, I hope you're well.

I wanted to ask if I can copy multiple rows, at the same instance?

Thanks and Regards,

Shubhangi Agrawal