Hello All!
Is it possible to create an array from a database based on a specific value in a column.
I have a excel spreadsheet with 2500 rows and 100 columns.
I need to create an array for all columns but rows only if col x has certain values.
Since its a large no of coloumns and rows I am using the below to store data in the array vs assigning values manually.
myArray = myTable.Range
Is it possible and if yes how can it be done?
Thanks in Advance
Anshika
Is it possible to create an array from a database based on a specific value in a column.
I have a excel spreadsheet with 2500 rows and 100 columns.
I need to create an array for all columns but rows only if col x has certain values.
Since its a large no of coloumns and rows I am using the below to store data in the array vs assigning values manually.
myArray = myTable.Range
Is it possible and if yes how can it be done?
Thanks in Advance
Anshika