VBA To convert Formula(s) to Value(s) to track serial numbers

[geranuno]

Hello Everyone! I am not a developer (Just a passionate aficionado) but seriously need help


I am currently working on a project to track time of reworks units individually based on their serial numbers.


At this point I did the Index-Match to identify the rework unit, but when I scan another serial number, it erases my previous data.


This can be avoided if I just paste-special-values of the serial number in matter at the corresponding location (Next to the Original input number)


Here's an image for reference:




Any help using formulas or VBA will be greatly appreciated!

Thanks so much

GN

 

[Sektor]

This should work:

Sub ConvertToValues()
    With Range("C4:C" & Cells(Rows.Count, "C").End(xlUp).Row)
        .Value = .Value
    End With
End Sub

 

[geranuno]

Hey! thanks so much Sektor!

The code your recommended it convert values to all the 'C' column. (And I don't want to do that)

In reality what I need is to create a loop that convert just the number we are scanning One by One ...and leave the formula when 'Units not ready'

How can I loop to search the value and replace it on next column ... but paste-values just the scanned number ....

Am I clear Sir ?

Thanks again for the follow-up and quick respond!

GN