Hi Guys,
This may end up being really simple, but ive hit a wall with this.
i have a worksheet of data, with ambulance call signs. Is it possible for excel to search if the call sign is in the raw data, if it finds any of the call signs then it moves all of the information contained within the row, related to that call sign, to a seperate worksheet?
the downside is there are 109 different call signs that could be within the data so it would need to search for all of them in one go?
if anyone could help it would be greatly appreciated.
Thank you
Terry
This may end up being really simple, but ive hit a wall with this.
i have a worksheet of data, with ambulance call signs. Is it possible for excel to search if the call sign is in the raw data, if it finds any of the call signs then it moves all of the information contained within the row, related to that call sign, to a seperate worksheet?
the downside is there are 109 different call signs that could be within the data so it would need to search for all of them in one go?
if anyone could help it would be greatly appreciated.
Thank you
Terry