Z
Zippy
I have two columns of information with a label for the information in column
1 and the data in column 2.
However the data is offset from the labels eg
blank cell Data 1
Label for Data 1 blank cell
blank cell Data 2
blank cell More Data 2
Label for Data 2 blank cell
Label for Data 2 blank cell
blank cell Data 3
Label for Data 3
Now what I want to do is write a macro in Excel 97 to align the data with
the labels.
This apparently simple task (because the number of data cells should equal
the number of label cells for that data and the number of blank cells below
each line of data should equal the number of lines of data) has a spanner in
the works because every now and then the data is missing and here I want to
add a comment to that effect in the data field (before or after realigning.
eg
Data 998
Label for Data 998 blank cell <-----Comment to add here
Label for Data 999 blank cell <-----Comment to add here
Label for Data 999 blank cell
blank cell data 1000
Label for Data 1000 blank cell
To do it manually would take forever as there are thousands of lines of
data.
Is there anyone who can point me in the right direction please.
1 and the data in column 2.
However the data is offset from the labels eg
blank cell Data 1
Label for Data 1 blank cell
blank cell Data 2
blank cell More Data 2
Label for Data 2 blank cell
Label for Data 2 blank cell
blank cell Data 3
Label for Data 3
Now what I want to do is write a macro in Excel 97 to align the data with
the labels.
This apparently simple task (because the number of data cells should equal
the number of label cells for that data and the number of blank cells below
each line of data should equal the number of lines of data) has a spanner in
the works because every now and then the data is missing and here I want to
add a comment to that effect in the data field (before or after realigning.
eg
Data 998
Label for Data 998 blank cell <-----Comment to add here
Label for Data 999 blank cell <-----Comment to add here
Label for Data 999 blank cell
blank cell data 1000
Label for Data 1000 blank cell
To do it manually would take forever as there are thousands of lines of
data.
Is there anyone who can point me in the right direction please.