I am sorry for being unclear and am ignorant about how to adjust macros, unfortunately. When I say blocks of text, I mean the grouping of eight categories that I want to go as column headers in Excel and the text after each of them, that goes below each of them in the spreadsheet - each group of eight I am calling a block of text. I will have many of these to convert to a spreadsheet with one row of headers and the data for each header below it in the spreadsheet. I am pasting 3 "blocks of text" below as a more extensive example of what I have in Word. I only need the bold category headers to be in the first row of Excel as column headers and the text after each colon to go sequentially below the appropriate header.
Example:
Category: Modules
Issue: Scheduling
Description: EPM has not been utilized thus all departments are using scheduling in manual ways or using Excel, Access, and/or corporate-driven systems. This does not link in with clinical encounters, creates inefficiency, limits reporting capabilities, and makes it impossible for departments to see appointments for the same patient across multiple departments.
Impact: Productivity, Continuity of Care, Quality of Care
Departments Affected: All
Scope of Problem: Widespread
Severity: Very High
Possible Solutions: EPM to be installed and staff trained on how to set it up and utilize it.
__________________________________________________ __________________________________
Category: Modules
Issue: Reporting
Description: There are very few preloaded Crystal reports. Staff has not been trained on how to create reports using the NextGen reporting module and many complaints that it is difficult and not user-friendly. Feedback suggests there is a strong desire/need for multiple reports to be prepopulated for statistical means, tracking, and compliance with state and accreditation standards.
Impact: Productivity/Efficiency, Quality of Care
Departments Affected: All
Scope of Problem: Widespread
Severity: High
Possible Solutions: Departments to provide copies of reports that are needed with variables needed. Reports can be pre-programmed for simple access and easy reporting.
__________________________________________________ __________________________________
Category: Modules
Issue: Chart Organization
Description: Widespread complaints that using the history view is very difficult to use, especially with inmates who have been in the system for some time. There are too few documents types to distinguish between documents (e.g., multiple types of notes across mental health and psychiatry print as BH_Master). There is little to no ability to filter or search by type of note or provider name. Sometimes staff is not able to find what they are looking for in a reasonable amount of time.
Impact: Productivity/Efficiency, Patient Safety, Continuity of Care
Departments Affected: All
Scope of Problem: Widespread
Severity: High
Possible Solutions: Documents within disciplines need to have a sufficient variability in name to be able to differentiate exactly what type of document it is. Category view is currently poorly organized and needs to be reconfigured to allow staff to more efficiently search for documents by category and date.
|