Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Imported dates | Excel Discussion (Misc queries) | |||
imported text data converting to dates | Excel Discussion (Misc queries) | |||
Imported numbers change to dates | Excel Discussion (Misc queries) | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |