Recall Line of Data to Manipulate/Change

I am looking for a piece of code that will help me give each individual line item in a database a tracking number. For example:
1.1A=Test data 1
1.2A=Test data 1, sub part b
2.1A=test data 2
2.1A test data 2 sub part b

In addition to that, I would like to be able to bring this line of data back up and manipulate it/change it, rather than adding an additional line of data with 90% of it the same, only to change one or two cells.

For reference, here's my current ode-pretty simple just log and dump type of database. Using it for visuals mainly.

Sub TestDump()
 ' EnterData Macro
 
 Range("A5:Y9").Select
 Selection.Copy
 Sheets("Test Data").Select
 Range("A1048576").End(xlUp).Select
 ActiveCell.Offset(1, 0).Range("A1").Select
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
 Sheets("Log Sheet").Select
 Application.CutCopyMode = False
 Selection.ClearContents
 Range("A5").Select
 
 MsgBox "Data has been dumped!"
 
End Sub
Nick RobsonPerformance Improvement Analyst IIAsked:
Who is Participating?
All Courses

From novice to tech pro — start learning today.