Code for referring to a cell in another sheet

[jazzkid]

I also need another chart for each patient for the year. In this I need to refer on the sheet "Weight Record" to a cell in a second sheet called "MNA".

I've tried a few formulas - but not making it. If anyone can assist with the formulas in column "I" rows 13 - 25 I would really appreciate it.

Thanks again for any assistance

Sue

 

[Hui]

Jazzkid

You can setup a Lookup table and then Vlookup the value from the ranges in that
But they will be the same for each month as there is no link from the MNA sheet to the Weight record entries

That is you will need to record each of the 6 MNA components for each month if you want an individual measurement each month

See attached

 

[jazzkid]

Thanks

That works well. As you say, if the MNA is needed to be done each month, that will have to be a separate calculation - but easy to setup.

 

[Hui]

Have a look at:

 

[jazzkid]

The only issue I have is with the cells in column C which have not been completed due to that month's weight not being done yet. If I copy the formula into column I, I get whatever the phrase is in the Lookup table for the corresponding range. Thoughts on how to rectify this? I have uploaded another file to show this.

 

[jazzkid]

Thanks Hui

Not sure how - but I missed your last post as you can tell from my last post. Not sure about the last file. The MNA is needed to be calculated, and I wanted to set this up so that when the MNA is done the cell/s in column O will populate automatically.

Have to think about that. Talking to a dietician today, the MNA is possibly done every 3 or 4 months, not every month.

 

[Hui]

So change the code so that if the MMA is 0 then it isn't applied

 

[jazzkid]

Thanks Hui

I hadn't looked at the chart correctly. That's great!!