Please see the attached workbook. I have a form in which the user will populate various cells with Chemical Application information. I need to get this data and populate a table to provide a running record of all chemicals applied, where, when and other data points. The approach I am trying now is a dynamic vba array whose elements are defined as:
Rows = # of Chemicals Applied
Columns = 29
I have included the expected result of the Macro in the Chemical Application Records tab of the attached workbook. The Chemical data is highlighted in green and the rest of the data points are highlighted in red.
I am using the following code:
When I run the macro, I get a 1 dimensional array of 28 columns when I should have a two dimensional array of 4 rows x 29 columns.
Please Login or Register to view this content.
Thank you all.