Forum Discussion
PallaviN
Jan 21, 2024Copper Contributor
want to copy the data from one sheet to different tabs automatically
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. I...
Patrick2788
Jan 21, 2024Silver Contributor
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.