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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.