Collect Data into Array and Transfer from One Sheet to Another based on variable

[fiasco]

Hi All,

I am new to VBA and have run into a piece of work that requires an array.

Using VBA, I am wanting to achieve the following outcomes:

1. Collect dynamic data (size ranges between 100 rows and 20,000 rows at any time) from sheet f where column I (labelled as NotPresented) is greater than 0 or is greater than "" (i.e. not blank cell) into an array of 9 columns
2. Transfer the results of this array into a specific range (a21, b21, c21, and so forth) in sheet t

I am sure there are many people whom have done this before so any help would be greatly appreciated.

Thanks

[AB33]

Unless I am missing something, why do you need an array? You have a condition in which column I is >0. A simple filter will do the job.

[stnkynts]

Why use an array. Try this:

Please Login or Register  to view this content.

[fiasco]

Hi guys. Thanks for the replies and help so far.
In response to your suggestions, I specifically asked for help with using an array as I want to learn how to use this method in other areas of my project.
I realise now based on your responses, that I do not need an array to facilitate my outcome, however, for the purpose of learning, I would like to receive assistance based on the original request.
Thanks in advance.

[fiasco]

Hi again. To construct this array, would I use ADO or DAO as the recordset model?

[AB33]

ADO usually used to copy data from closed workbook. I do not know how it is relevant to your request.