Hi everybody! I have a very simple spreadsheet with all the data in sheet 1. I would like to split that data into different sheets. I tried vlookup, and can find the first match, but no second or third match.
<tbody>
</tbody>
I then want sheets named "Potholes", "Streetlights", "Water Leaks" with the Pothole sheet containing the 3 instances and names.
Thanks a stack in advance!
Jo
Windows 7, Excel 2007
Potholes |
<colgroup><col width="101" style="width:76pt"> </colgroup><tbody> </tbody> | John | |
Streetlights | 8/6/ 2017 | Peter | |
Water leaks | 3/4/2017 | Dave | |
Potholes | 1/6/2017 | Adam | |
Potholes | 3/2/2017 | Pete | |
<tbody>
</tbody>
I then want sheets named "Potholes", "Streetlights", "Water Leaks" with the Pothole sheet containing the 3 instances and names.
Thanks a stack in advance!
Jo
Windows 7, Excel 2007