Loop through columns then next row with unit convert

[cnash52]

All of my attempts to simplify this lop have failed an every change I have to make to the if statement has to be made over and over for all lines. Starting at the second row it is supposed to check to make sure the cell in column 5 of the current row is greater than zero to start reading through the rows. Then to check the value in the top cell of the current column and if its value matches one of the two values listed in the if then statements. Values range from -2.11 to 2.1. If the statement is satisfied then the corresponding value of the row and column would be converted from meters to inches and written to the new sheet "Upchain Edit" in the column with the corresponding column header value instead of equaling line = line +BLAHBLAH.

Example new sheet header layout:
Excel.JPG

Please Login or Register  to view this content.

[Kaper]

seems that you have very systematic change - why not use another loop?

Please Login or Register  to view this content.

[cnash52]

I tried something like this but when there is a value in the Header and Header-0.1 then it would get messed up.

Please Login or Register  to view this content.

[cnash52]

When there is a value in both of the if statement headers then the statement is satisfied twice for one row and ends up offsetting incorrectly in the new file.

[Kaper]

there is huge difference between

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

can you see it?
if not, try in immediate window:

Please Login or Register  to view this content.

[cnash52]

As I run he below code I get several empty cells and zero cells

Please Login or Register  to view this content.

Here is an example of what the newly created "Upchain Edit" looks like
Excel.JPG

Looking at the csv in the first post U4 would be the first non-zero value that falls within the if statements and should be placed in cell C2 of the new sheet and the first one works.
Excel.JPG

Then it goes right back to blank for D2 when there should be a value corresponding to AF4 if converted from meters to inches.
Excel.JPG

[cnash52]

If anyone could help me with figuring out why the loop is leaving so many blanks it would be greatly appreciated. Kaper helped some but the loop still isn't working correctly and he has messaged me to let me know that he isn't going to "waste his time" assisting further and is quitting this thread. Thank you very much in advance.

[Kaper]

Indeed.
The code snippets are far from complete.
Such variables as CurSta, StartStation, Direction, etc are probably meaningfull, but only for Author, and not for those who try to help.
Data format in csv is different than screenshots.
...
So please join us.
t could be just mine deficiency with interpreting what is available and helping.
And someone with fresh view could help in no time.

[cnash52]

Those three variables have no effect on this loop and are from a prior loop. I plan to add them back in but I have to get this loop to call the values correctly first. I don't know if this will help but I have been fighting with this all day yesterday.

I have attached a macro enabled version of the worksheet. The button on the first sheet will open the form. The first button "Get Upchain File" will direct you to a browse window to select the reference file (the attached csv). You can use the same file for upchain and downchain because downchain is not set up yet. Nothing needs to be entered in pin or start station. When you click "Process Data" the macro involving the issue loop will run. It is supposed to reference the data in the "Upchain" sheet and run through the loop slimming down the data and writing to the "Upchain Edit" sheet based on the if statements. I believe there is something wrong with the if statement because when A=4, B=32, C=3, and i=2 there is a value in the "Upchain" sheet that should satisfy the if statement but it skips to the next C as if it doesn't satisfy the statement. This is the first instance of incorrect read/write.

If there are any questions please feel free to ask.

The MsgBox if statement on line 103 was just for trying to locate the issue and can be deleted.

[cnash52]

The error was in the convert function all along. Remove the function or have it go from"m" to "m" and it populates correctly.