Copy live data from certain columns from one sheet to another

Crystal Perry

I have a very large sheet with 58 columns and over 3,000 rows but continually adding until it gets full them with push to a new sheet. Anyway I want a new sheet that references the data in only a few on the columns in the primary sheet. I tried using INDEX function but I'm unable to get it to work. Is this the best option. I don't think V-lookup will work since all of he columns are in random areas of the current sheet. I have attached a screen grab of some of the columns I want to see in the new sheet.

Capture.JPG

Andrée Starå

Hi @Crystal Perry

I hope you're well and safe!

You could add an Auto-Number column in the main sheet and then add the number manually to the second sheet and use that to collect the columns you need.

Make sense?

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!

Crystal Perry

No I'm sorry, I'm not following. I do have an auto number column already in the main sheet though.