I've tried various things but I can't figure it out. I redim the array so I don't know why I keep getting the subscript out of range on the array. I have tried it two different ways. The program runs but the array doesn't populate correctly.
I have 4 columns of data, if the last column (D) has NA (from a previous formula) I want to write that row's values in Column A & B to the first line of an array. I will then use that array to provide information via a userform to the end user who will populate the information for the 3rd & 4th variable of the array -- all of the information will then be transposed to a master spreadsheet that is updated weekly.
Any help is greatly appreciated!!HTML Code:
Thank you
Bookmarks