View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffP jeffP is offline
external usenet poster
 
Posts: 38
Default matching dates from imported *.dbf file?

HI all,
I have a simple WS of 3 columns date,custnum,invnum that has dates over past
5 years. I simply want to have user input the date desired and get
corresponding data to another WS. I'm sure there are many ways to do this
and I thought I'd try working w/ Advanced filter.
My problem is that I can't get my user input date to match up with anything
in the imported database date. I tried all kinds of formatting and even
tried copying a cell from the import data and paste it into the user data
cell. It won't match up even with itself!

Could you explain to me what I am missing?

--
jeff