I need excel consultation

Dear All

Thanks for this great site, it helped me a lot.
I have one problem I need your help or consultation.


I have two sheets with two tables
1st sheet: has patients data
includes there visit number and visit date and visit operation with his own unique hospital number
each visit recorder it will comes in one row, that means if he has 5 visits the variation will be in row number and date and his visit's number.

2nd sheet: Has table, we enter only patient id or hospital number, and value recorded for his investigation.


what I need:

every time we entering his hospital number at sheet 2 it will be added to sheet 1 at cell (CA column) in his LAST visit row the value 100 (this investigation reading value).


If friend can help me for equation so I can do by equation or simple vba code.

here my equation I added it at CA column, but if the patient has two times visits this equation will change all his previous visited investigations also???!!!

=IF(OR($E3813=$EO$8,$EO$20,$EO$22,$EO$23,$EO$24),1,IF(AND(((TODAY()-($V3813))>=14),E3813=$EO$10),(IFERROR((VLOOKUP(CD3813,HCGNEW,2,0)),0.1)),IF(AND(BK3813>=1,((TODAY()-($V3813))>=12)),(IFERROR((VLOOKUP(CD3813,HCGNEW,2,0)),0.1)),1)))[/QUOTE]

Hi - please don't post in more than one subforum.

Originally Posted by yudlugar

Hi - please don't post in more than one subforum.

sorry for disturbance.
but
what means of subforum

You posted the message in both the "vba/programming" and "formulas/functions" areas of the site. I'd suggest having a read of the forum rules, this will help get your questions answered quicker.