Help required with putting data into comments fields

[mearmortal]

I load the txt file into excel format with delimited set with TAB and other | character
Delete the lines down to and including Row27 and select the first cell.
I run the clean macro first removing unwanted text.
Running the second macro does the following: -
It creates a seperate sheet with the information formatted horizontally.
What I would like to do is have the second row which has number in places sometimes and not in others, put into comments on the line above. giving the association.

In doing this the second line becomes redundant and the remaining lines can be moved up 1.
I would like to know how this can be achived.
I have included a zip file with the relevant information.
Can someone assist me please.
Thanks.

 

[SkipVought]

Sorry, can't open.

Please post a cogent example HERE.



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Do you have any code?

Have you tried to record a macro?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mearmortal]

Strange it's only a rar file.
I've recorded Macro's before, but the VBA script I'm using is working on Offsets a lot and I don't know enough about VBA to workout the differences.

The Script was given to me by another colleague.

Find attached the first file

 

[mearmortal]

Find attached the second file

 

[SkipVought]

What is your SPECIFIC question?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mearmortal]

Running the second macro does the following: -
It creates a separate sheet with the information formatted horizontally.
What I would like to do is have the second row which has number in places sometimes and not in others, put into comments on the line above. giving the association.

In doing this the second line becomes redundant and the remaining lines can be moved up 1.
I would like to know how this can be achieved.

 

[SkipVought]

Post your code that is not working as desired.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]