Hello board of experts!
I hope you can help me. I've been searching around the forum, and there are a lot of great macros and VBA code, but I'm pretty much stuck anyway. I'm a newbie at excel, and VBA, just starting to learn. The subject is a recurring one, and I'll post an example
I'm a phd student (medicine) starting up a project this summer. I'm going to follow up a lot of patients initially one day after they get admitted to our department.
We have an electronic patient chart, but the problem is, that our hospital won't buy software that can export the values I'm collecting. But it's possible to export these values to excel, but I need to clean up the data. My goal is to export these cleaned up data to an access database and in the end doing statistics in STATA.
A final thing is, I'd like to split up the bloodpressure into systolic blood pressure and diastolic blood pressure
I know this is a lot to ask for, but I really hope you guys can help me. I've tried with find and replace, but as stated before, i'm stuck :-)
edit: hope you can see what i'm trying to do. I'm having trouble with the tables here (i bet im not the first :-) ) I'll post an excel example later
Cheers Daniel
Bookmarks