Hi,

I've been trying to find a means of doing this all afternoon but I'm struggling to find something that meets my requirement.

Basically I have a spreadsheet which has a very large number of rows (upwards of 900,000) and approx 5-6 columns. The first column contains a reference number in the format 12345/123 and what I'm trying to do is poll the first column looking for instances of a specific reference and, when found, to extract all the columns for that row and write them away as an object.

The thing I'm struggling with is polling the data and extracting the requisite columns - I can do it with a counter which iterates and reads through every cell in the column but this seems a very unoptimised way of doing it and takes far too long. Is there something I can do using range to quickly poll the first column and I can then either call a function or process some code when it finds one which will lift the accompanying data?

Thanks in advance.