Hello Excel Community -
I am working on a project to centralize data that we collect onto a workbook. I have been looking around on different forums and websites to guide me on this but I have not had much luck. There is a master spreadsheet holding all crucial data with a face page sheet to have buttons to run all the macros I am going to set up, and here are some of the goals of the macros I would like to set up:
Master Disease Sheet
<tbody>
</tbody> --> the code would be written to move certain details from the row to another sheet for all disease specific events (Disease Type: Ovarian to move to sheet named: Ovarian, etc), and to look like this:
<tbody>
</tbody>
I have been following tutorials online for the coding mechanism but I am not having much luck. Any guidance on this would be really appreciated.
Thanks!
I am working on a project to centralize data that we collect onto a workbook. I have been looking around on different forums and websites to guide me on this but I have not had much luck. There is a master spreadsheet holding all crucial data with a face page sheet to have buttons to run all the macros I am going to set up, and here are some of the goals of the macros I would like to set up:
- Archiving Events -- essentially copy and pasting rows based on a the text within a cell (Complete/Cancelled) into an archive sheet, to show only current and up to date events on the master sheet
- Copying Rows based on different words onto their respective sheet for example: All 'sub type columns' will move from the master sheet into the breakdown sheet (this sheet is to essentially track events based on a specific disease type)
- Copying rows and only certain columns from each row into another sheet and to have it paste it several times depending on the number in one of the cells; example:
Master Disease Sheet
Date | Name | Time | Presenter | Completed | Disease Type | # of cases presented |
1/10/18 | Ovarian Overview | 6:00 pm | Dr. Smith | Complete | Ovarian | 5 |
1/10/18 | Prostate | 7:00 pm | Dr. A | Complete | Prostate | 3 |
<tbody>
</tbody>
Date | Name | Presenter | Case # | Pt # | Care Plan | Follow UP Plan |
1/10/18 | Ovarian Overview | Dr. Smith | 1 | |||
1/10/18 | Ovarian Overview | Dr. Smith | 2 | |||
1/10/18 | Ovarian Overview | Dr. Smith | 3 | |||
1/10/18 | Ovarian Overview | Dr. Smith | 4 | |||
1/10/18 | Ovarian Overview | Dr. Smith | 5 |
<tbody>
</tbody>
I have been following tutorials online for the coding mechanism but I am not having much luck. Any guidance on this would be really appreciated.
Thanks!