Excel Question---help me!!?

Question

how do you make a column to where it will not let me duplicate something that is already in that column?

In column A I have a list of numbers. Each day I have to add more to the end of the list, but I cannot duplicate them. Can it be set up to where it either warns me or does not allow me to type in a number that is already in that column?

Answer 1

Select Tools-Macro-Visual Basic Editor. Select the sheet that you are working on and copy this code onto the right side.


Private Sub Worksheet_Change(ByVal Target As Range)
For counter = 1 To Target.Row
If Target.Value = Cells(counter, Target.Column) Then
MsgBox "This value is the same as in Row " & counter
Exit For
End If
Next
End Sub

This should pop up an error message whenever you try to replicate a value that is already in the column. It might slow down performance if the spreadsheet gets too large.

Answer 2

Have you cleared the formatting, or turned off the auto-fill? Is that what's happening? Are you talking about where it finishes typing a word for you? If you keep typing what you want it won't auto-fill.
I hope I helped but I think I may not have understood your question!
Ps. It took me MONTHS of self teaching to get the hang of Excel, and their 'type a question for help' isn't always very helpful at all!

Answer 3

I use Microsoft, use a 2 columnn page, landscape, print you first colum then, copy and paste it on the next column.

Answer 4

Can you re-word that question a bit better? Basically, it is unintelligible.

Answer 5

right click, format