Results 1 to 6 of 6

Thread: Solved: Data double validation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Jan 2008
    Posts
    104
    Location

    Solved: Data double validation

    Good night everybody.
    I got a question about data validation. How can I validate the data entry of a Sheet where the user by the action of pressing a macro button input current day summary data. What the macro does is copy at the end of working day totals of data collected and paste it to a table and a chart plots the data automatically.
    My question is; how can I validate that the data is not entered twice and at the same time validate that is enter?
    The data copied has a cell with the current day date that I think will be key for the validation. Here is the macro I wrote to paste the data;

    [VBA]Sub PasteDailyData()
    Application.ScreenUpdating = False
    Sheets("TAG-CHART").Select
    Range("K87:U87").Select
    Selection.Copy
    Sheets("TAG_HISTORY").Select
    Range("A1").Select
    Do
    If IsEmpty(ActiveCell) = False Then
    ActiveCell.Offset(1, 0).Select
    End If
    Loop Until IsEmpty(ActiveCell) = True

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False
    Sheets("SWITCHBOARD").Select

    End Sub[/VBA]

    types copied are;
    Date, Percentage, Percentage, Percentage, Percentage and Number.

    Sample workbook is attached.

    Any ideas are in advance greatly appreciated
    Last edited by IgnBan; 03-06-2008 at 07:14 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •