Macro or formula to fill in next number in series

[mcranda]

I am looking to fill in the blanks with the next series of the number for column B - Customer Material Number.

For example -
Line 1089 - 1702 43 05 ALT4
Line 1090 - 1702 43 05 ALT5

The spreadsheet is sorted on...
Level 1 - SearchTerm
Level 2 - Customer Material Number
This aligned column B's blanks to filter after the number series.

Thanks.

[mcranda]

Please Login or Register  to view this content.

I found the above code. I tried to change "A" to "B" but it didn't work. I am guessing I need to change the .value line.

[AB33]

If you are simply trying to fill up with the above number, no need for a code, use excel function called go to.

[mcranda]

I need a number added to the number above.

[AB33]

Please Login or Register  to view this content.

[mcranda]

That macro does not add +1 to the previous record. Also, the macro should only add a number to ALT. MFG Obsolete and removed from standards should be ignored.

[AB33]

I have only adjusted some of the error lines and did not look at the last line

[mcranda]

I am getting an error on the last line and it is not adding 1. I am trying to break down the last line...but not getting anywhere.

[AB33]

I did not get any error, but the code will not work if you put conditions. It indiscriminately apply the formal while you want to exclude some rows, so a loop would be the solution.

[mcranda]

I am first sorting on SearchTerm then on Customer Material Number (A to Z)
Then I ran the macro and I get a runtime error. Pictures are posted errors.

What am I doing wrong?

Also, the series is still not adding +1 to the previous number.

[AB33]

Look at the attached. I have left the original as it is, copied it and used the code. The code works as per formal. Compare both sheets.

[mcranda]

The macro is not working...

Line 1204 should be 1705 58 00 ALT 7 (because the last record in the group 1705 58 00 (searchterm) is ALT 6
Line 1205 should be 1705 58 00 ALT 8

...this is the result the macro gave.
1705 58 00 478303304
1705 58 00 478303304

[AB33]

The macro is not working is not the same as you are getting errors.
You are the one who came up with formula. You know what you wanted. I have only corrected the error lines.
The code does not search anything, it copies the row above if a cell is blank in column B. There is no exception to any cell.
It applies to entire column B.
If you want to exclude certain rows, you need to loop through the rows, the code you have does not loop thorough.

[mcranda]

I copied and pasted the formula and noted that the value line probably needed to be changed. I am writing on this thread because I don't know how to write that script.