want to copy the data from one sheet to different tabs automatically

Copper Contributor

Hi, I have a excel data sheet. Where a Column of ID having different ids and in another column there is data for those ids. I just want to populate the data from that sheet to new tabs for each id. Ids are unlimited so each time a new id created and the data is refreshed I want that ID's data into new tab. 

I need help with this task. Thanks in advance!

1 Reply


The FILTER function is capable of doing this task. Another option is to keep the data all in 1 central location and use filtering/sorting/pivots, sheet view, etc.