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.
' EnterData Macro
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Application.CutCopyMode = False
MsgBox "Data has been dumped!"