Jan 20 2024 08:30 PM
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!
Jan 21 2024 02:46 AM - edited Jan 21 2024 02:47 AM
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.