Thanks for the help!!! I think it all works now. I just run out of column identifiers once it gets past Col Z so going to fix that. It does all the columns up to that though!!!
I have changed "Date" to "InfoDate", and here is an example of the "Raw" data, though the blank heading does not exist, it is just to illustrate the blank column as it is not very clear otherwise. This is 5 columns worth.
Observation D Observation A
Date Size Blank Date Size
03/01/1989...
These are the watch results:
Watch : : ArrayEnd : "D7000" : Variant/String : Module2.MacroDateAlign
Watch : : ArrayStrt : "D1" : Variant/String : Module2.MacroDateAlign
D1 and D7000 are the correct values.
Any ideas?
Thanks for the help.
I have a sheet of data ("raw") containing multiple pairs of columns of dates and corresponding information under one overall heading, and another sheet ("Date Aligned") with the full list of dates in the first column and the headings from from the previous tab along the top of the sheet. I need...
I have a sheet of data ("raw") containing multiple pairs of columns of dates and corresponding information under one overall heading, and another sheet ("Date Aligned") with the full list of dates in the first column and the headings from from the previous tab along the top of the sheet. I need...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.