• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

Micosoft Excel: Checking data in the rest of the row

I have users entering data into expense sheets.  My import looks for dates in column A and throws an error when there is no amount and a date entered.   I need some code that will check that the row is correctl formatted.  Has anyone done anything similar?

Any help appreciated. Richard
0
RichardH1976
Asked:
RichardH1976
  • 2
1 Solution
 
jppintoCommented:
You need to post a sample sheet. This way is a shot on the dark!
0
 
jppintoCommented:
To insure that users always enter valid dates on column A, use Data Validation List and set it to Date so that it only accepts valid dates on that column.
Capturar.JPG
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now