Hi There,
I have a very large table of data, when I say large, I mean 285,000 rows large. I don’t think my managers realise how much data there is, anyhow unfortunately for me this isn’t stored within a SQL database or access table and I don’t have either of these available to me.
I say unfortunate because I have to write a report on this set of data and I need to eventually make it run automatically using VBA. My natural inclination is to run queries on the data just like with SQL
e.g SELECT * FROM Sheet1 Where ID=’1’ Price=’2’ etc....
But I don’t know how to do this using VBA
I’m sure VBA has a very easy to use alternative for this kind of thing and I don’t want to re-invent the wheel. I would want to select the relevant data and write this into another table for analysing.
Does anyone know of a good solution?
Cheers in advance.
Nick
I have a very large table of data, when I say large, I mean 285,000 rows large. I don’t think my managers realise how much data there is, anyhow unfortunately for me this isn’t stored within a SQL database or access table and I don’t have either of these available to me.
I say unfortunate because I have to write a report on this set of data and I need to eventually make it run automatically using VBA. My natural inclination is to run queries on the data just like with SQL
e.g SELECT * FROM Sheet1 Where ID=’1’ Price=’2’ etc....
But I don’t know how to do this using VBA
I’m sure VBA has a very easy to use alternative for this kind of thing and I don’t want to re-invent the wheel. I would want to select the relevant data and write this into another table for analysing. Does anyone know of a good solution?
Cheers in advance.
Nick
