Hi,
I have two tables, one of them contents database of received material &
other one is the summery of that sheet. The unique field name in both the
sheet is "im_code
" &"im_invrt". Now i wish to pull the latest "im_invrt" from the database
sheet for the given criteria of "im_code" in the summery sheet. I have tried
this by using DGET / DMAX function. but the value returns #NUM!.
Both the sheets are looks like :
Sheet Dbase contents
doc_no im_code im_qty im_invrt date_stmp
GR700144 ATM0093 100 626.02 05/04/2006 07:45:01 AM
GR700147 ATM0093 60 726.02 05/04/2006 07:54:49 AM
GR700148 PTM0748 20 642.72 05/04/2006 07:57:11 AM
GR700152 ATM0093 40 626.02 05/04/2006 09:22:23 AM
GR700185 ATM0762 40 626.02 05/04/2006 06:09:43 PM
GR700193 PTM0748 39 650.72 05/04/2006 06:45:37 PM
GR700185 ATM0762 57 642.72 07/04/2006 04:19:33 PM
And Sheet Summery contents :
im_code im_invrt
ATM0093 =DGET(DBASE!$A$1:$E$8,"IM_INVRT",SUMMERY!$A$1:$A$4 )
PTM0748 #NUM!
ATM0762 #NUM!
Is their any solution to pull the latest data (i.e "im_invrt") in the
desired rows.
--
Thanks,
Vikram P. Dhemare