Hi,
Its been quite some time that I have visited this site. been preoccupied with other assignment at hospital.
I would seek your help in solving this situation, required in managing Turn around time in the laboratory.
I have an excel sheet (OfficeXP/Office 2003), where in Sheet1, I enter certain data like a test name from a drop down list (saved in Sheet2). Once the name is selected, I need few additional data adjacent to test names in Sheet-2 to be copied in the respective columns in Sheet-1.
Example, Pl see the attached workbook.
Sheet-2
Col A=Test name B=Instrument C=Time in minutes
Row 1. A=Glucose B=Siemens C=10
Row 2. A=Tot. Prot B=Siemens C=10
Row 3. A=Albumin B=Siemens C=15
Row 4. A=DC B=Beckman C=22
Row 5. A=Electrophoresis B=Sebia C=15
Row 6. A=Immunoglobulins B=Vitrous C=30
Sheet-1
A= S.No., B=Pat Name, C=Pat ID, D=Test requested (as drop down menu from sheet2), E= Sample Col Time & F=Report deliver time (this will be calculated as E+20(for sample processing)+Sheet2!C - corresponding to the test requested).
What I would require is, once the test name is selected, then Col F should also get updated. Col E will be updated using IF & time function.
Will this require any macro or can be done using function formula?
Appreciate your support and any suggestions in this regard.
Thanks in advance.
Regards
Daavis
The attached workbook:
TAT calculation.xls
Bookmarks