Hi everyone!
I work in medicine and have a data analysis project I'm trying to work on. The basic premise is that I have an excel workbook that's the output of a database search of our radiology records system (submitted a keyword search to radiology system, it output all results to this workbook). Now I want to look in my workbook and find every instance that a particular keyword was used (for example every time the radiologist used the word "heterotopia" in their report). For every instance that my keyword was found, I want to output the patient's information to a new clean workbook. A complicating factor of this is that the radiology system output the data into 17 sheets, each with about 60,000 rows.
Here's an example screenshot of what this looks like: https://imgur.com/a/HTO93J0
The patient info is always the row above the report, but the report is in those big merged cells.
This seemed like a perfect time to use a macro, but I have no experience writing them, much less dealing with things like big blocks of text in merged cells. Any help would be appreciated!
I work in medicine and have a data analysis project I'm trying to work on. The basic premise is that I have an excel workbook that's the output of a database search of our radiology records system (submitted a keyword search to radiology system, it output all results to this workbook). Now I want to look in my workbook and find every instance that a particular keyword was used (for example every time the radiologist used the word "heterotopia" in their report). For every instance that my keyword was found, I want to output the patient's information to a new clean workbook. A complicating factor of this is that the radiology system output the data into 17 sheets, each with about 60,000 rows.
Here's an example screenshot of what this looks like: https://imgur.com/a/HTO93J0
The patient info is always the row above the report, but the report is in those big merged cells.
This seemed like a perfect time to use a macro, but I have no experience writing them, much less dealing with things like big blocks of text in merged cells. Any help would be appreciated!