+ Reply to Thread
Results 1 to 7 of 7

Splitting cells, rearranging columns and rows, cleaning up data

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    4

    Splitting cells, rearranging columns and rows, cleaning up data

    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
    Last edited by daniel.henriksen; 03-21-2010 at 11:13 AM.

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Hi Daniel

    It's difficult at best to "see" what your raw data looks like from the sample. Attaching a workbook with the raw sample data as you receive it would be helpful.

    John
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    03-09-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Hi John
    thank you for the reply. I know it pretty diffcult to see what I have in mind. I've attached the raw data, and right beneath it, how Id like it to be.
    As said before, I've managed to make a macro that cleans up the data. But it's the rearranging, and splitting up i have problems with.

    thank you again for the reply. I'm eager to learn
    edit: we're in the process of finding out the best way to solve this problem. I'll post a workbook when we're done
    Last edited by daniel.henriksen; 03-13-2010 at 04:25 AM.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Hi Daniel

    Working on it. Having an issue with the date cells in the raw data.

    John

  5. #5
    Registered User
    Join Date
    03-09-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Quote Originally Posted by jaslake View Post
    Hi Daniel

    Working on it. Having an issue with the date cells in the raw data.

    John
    That's great, thank you so much! Looking forward to see what you've created :-)

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Hi Daniel

    Play with the attached workbook. I believe the code does as you described. Let me know of issues.

    John
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-09-2010
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Splitting cells, rearranging columns and rows, cleaning up data

    Thank you so much John! The result is fantastic! It almost works :-) I have tried it on another set of values, and there's a little problem with the date and time. If it's ok, I'll send a PM with the example?
    This code will save me many many hours of manual data entry!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1