Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro and cell copy
I am a newbie with VBA and Macros and request assistance with a
spreadsheet I am tasked with to complete. Monthly, I export about 8000 records of lab data from our database and use it for QA spreadsheets. We now have a new value that management wwould like to be tracked. I have created a macro based on one I found on the the internet (sorry I can't rember the author)to extract the CALCM and PHOS data to a new sheet. That seems to be working fine for the most part. What I need to do now is multiply the CALM and PHOS results to come up with CXP result per patient, if the patient have both a CALCM and PHOS result for that Lab Date. Notice that a patient could have more than 1 set of results per month. see data below. Is there a way to make a macro to move PHOS results to Col I so I can multiply CALM and PHOS or is there a better way to accomplish this? Also to note, These macros will be performed by normal users so it should be as user friendly as possible. <data A B C D E F G H Chart# LName FName LabDate Lab result 111111 Lastname1 EMMETT 4/11/2005 CALCM 9.7 AD HEMO 111111 Lastname1 EMMETT 4/11/2005 PHOS 7.4 AD HEMO 111111 Lastname1 EMMETT 4/25/2005 CALCM 9.3 AD HEMO 111111 Lastname1 EMMETT 4/25/2005 PHOS 9.6 AD HEMO 222222 Lastname2 MARTHA 4/11/2005 CALCM 8.7 AD HEMO 222222 Lastname2 MARTHA 4/11/2005 PHOS 2.8 AD HEMO 333333 Lastname3 BETTY 4/11/2005 CALCM 8.2 AD HEMO 333333 Lastname3 BETTY 4/11/2005 PHOS 7.1 AD HEMO </data Any Help or insight with will be appreciated. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro and cell copy
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro and cell copy
Works like a champ...Thank You
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a macro into another cell? | Excel Discussion (Misc queries) | |||
Is there a macro i can use to copy a cell +1 | Excel Discussion (Misc queries) | |||
Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
Macro help - copy a cell down | Excel Discussion (Misc queries) | |||
Macro Help to Copy to Last Cell | Excel Programming |