Sunday, 6 March 2016

Avoid duplicate entries in a table

We use a table to enter all of our A/P invoices.  Is there a way to avoid entering an invoice twice by searching the cells above for the duplicate number for that vendor?  The vendor's name is entered in one column, the invoice # is entered in a different
Thanks for any help!

Solutions to the Problem Avoid duplicate entries in a table

Download SmartPCFixer to Fix It (Free)

You will need a macro to prevent any duplicates from being entered into your invoice table.
Assuming that invoice numbers are unique, i.e.
different vendors do not use the same numbers, try this macro:
Right click on the worksheet tab and select "View Code".
Enter the below macro in the top right window.
Private Sub Worksheet_Change(ByVal Target As Range)
  Set firstinvoice = Range("C2")
  If Not Intersect(Target, firstinvoice.EntireColumn) Is Nothing Then
    If Target.row > firstinvoice.row Then
      If WorksheetFunction.CountIf(firstinvoice.Resize(Target.row - firstinvoice.row), Target.Value) > 0 Then
        MsgBox "Invoice number " & Target.Value & " is already entered", vbOKOnly + vbCritical, "Invalid entry"
        Target.Value = ""
      End If
    End If
  End If
End Sub
Change the "C2" to the cell where your first invoice number is.
Hope this helps / Lars-Åke

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Fix the Problem: Avoid duplicate entries in a table:



How to Fix Avoid duplicate entries in a table with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Related: 50% Of The Times I Am In A MS Word, Or In An Email, And I Press Enter To Go To The Next Line To Continue Writing, Windows Mobility Center" Screen Shows Up.,Adobe Flash Player For Window 7,After Last Updates My Microsoft Word Starter 2010 Won't Work,Automatically Deleting Blank Characters Before Text In Line,Administrative Tools In Control Panel Is Blank. What Can I Do To Restore It?,Windows Backup And Restore Keep Popping Up,MS Word Starter, Omission Of Character,If I Use Two Or More Registry Cleaner. Does It Creat Any Problem To My Computer?,Screen Shot? - How To Take A Screen Shot,Parental Controls Not Working
Read More: Troubleshooter of Error: Getting error message when accessing Windows Mail,How to Resolve - why won't internet explorer 9 install???,emails not sending windows mail,How Can You Fix - when i try to access a program a window appears saying that windows cannot display the item because i may not have appropriate premission to access the item. what can i do to correct this problem??,Troubleshooting:My email inbox is full, how do I empty it Error,My troubleshooter keeps telling me it has an error and stops working.,several programs in the control panel wont allow me to access them, i dont think it's a virus. windows 7,How do I edit data in an embedded Excel object in a Word form document?,Message pops when I start FSX with an error code, stating that it was not possible to activate the product. Shuts down after 30 minutes of gameplay. HELP!,Excel Doc. won't launch in separate window

No comments:

Post a Comment