I need excel consultation

[x_ampl1]

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)))

 

[x_ampl1]

No support yet

 

[x_ampl1]

No update


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]

 

[x_ampl1]

Dear All

 

[x_ampl1]

Dear All

I need help