lynnaroo42
New Member
- Joined
- Nov 29, 2016
- Messages
- 2
Hello,
I am new to Mr. Excel and have exhausted my search engine trying to find a solution. Open to any ideas.
Our department does manual medical chart reviews. Each Chart review has its own worksheet. I then create a summary tab where I pull in the data from the other tabs to run stats on it. I enter the formula and try to use the fill series feature but the worksheets have to be manually updated. Below is an example.
<colgroup><col width="128" style="width: 96pt;" span="4">
<tbody>
</tbody>The age line is what I will get when I try to drag/autofill but the gender or CCM line is what I want. More specifically, I want the sheet to change as the variable rather than the cell.
Things I have considered: Macro (rows/data looking for changes), link (data in cell changes with each new audit), same work sheet (need it separate for staff to see their individual scores), & templates (rows/data looking for changes).
Much appreciated!
Lynne Emmons
I am new to Mr. Excel and have exhausted my search engine trying to find a solution. Open to any ideas.
Our department does manual medical chart reviews. Each Chart review has its own worksheet. I then create a summary tab where I pull in the data from the other tabs to run stats on it. I enter the formula and try to use the fill series feature but the worksheets have to be manually updated. Below is an example.
Age | =Sheet2!$B3 | =Sheet2!$B3 | =Sheet2!$B3 |
Gender | =Sheet2!$B4 | =Sheet3!$B4 | =Sheet4!$B4 |
CCM | =Sheet2!$B5 | =Sheet3!$B5 | =Sheet4!$B5 |
<colgroup><col width="128" style="width: 96pt;" span="4">
<tbody>
</tbody>
Things I have considered: Macro (rows/data looking for changes), link (data in cell changes with each new audit), same work sheet (need it separate for staff to see their individual scores), & templates (rows/data looking for changes).
Much appreciated!
Lynne Emmons