Forum Discussion
Kafrankel74
Oct 09, 2019Copper Contributor
New Excel user needing help!
Hello everyone! I recently started using Excel for personal use by creating budget worksheets. I have learned quite a bit and want to keep learning. In my job we have been using a Word table as a ...
Twifoo
Oct 10, 2019Silver Contributor
I recommend that you store the Information about Patients in Sheet1, Treatment in Sheet2, and Summary in Sheet3. Ensure that data are entered only once. Subsequently, they are either selected from a drop-down list or extracted through an appropriate LOOKUP formula. That is the essence of good spreadsheet design.