joemacintyre
New Member
Hi
I have a sheet that has 800 rows - the columns start at A and finish on IY. I want to be able to copy rows over to a new worksheet based on a criteria (organisation name). In any given row the organisation name will appear between columns FY and HY (ie on row 2 between FY2 and HY2). The organiastion name might even appear multiple times in the row but I only want to copy the row once over to the new worksheet.
As an example if "Organisation1" is mentioned anywhere on 100 out of the 800 rows of the rows I want to copy those rows into a new worksheet.
Can anyone point me to a Vba solution or one based somewhere else in excel.
Thanks in advance for your help and attention
I have a sheet that has 800 rows - the columns start at A and finish on IY. I want to be able to copy rows over to a new worksheet based on a criteria (organisation name). In any given row the organisation name will appear between columns FY and HY (ie on row 2 between FY2 and HY2). The organiastion name might even appear multiple times in the row but I only want to copy the row once over to the new worksheet.
As an example if "Organisation1" is mentioned anywhere on 100 out of the 800 rows of the rows I want to copy those rows into a new worksheet.
Can anyone point me to a Vba solution or one based somewhere else in excel.
Thanks in advance for your help and attention