How do you look for a phrase then get the value?

[Tarquine]

I am creating a spreadsheet to do my accounts.&nbsp;&nbsp;At the end of the month I need to enter the Stock Value, Cash in CashBox and Money in Account.&nbsp;&nbsp;Then make up the Monthly Financial Report.<br><br>What I want to do is setup the spreadsheet in such a way that:<br>1. It looks for me to type in a set phrase ie Stock Value.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>2. It would then take the value entered in the cell to the left or right of this and place it in an end of month financial report.<br>3. It would then do the same for the other two entries.&nbsp;&nbsp;The entries on the spreadsheet can cover 2,3 or 4 pages dependant on how busy the month was.&nbsp;&nbsp;These entries would need to go after the last normal entry, if that makes sense.<br><br>Any suggestions would be gratefully received.<br><br>Regards<br><br>Tarquine <p> <br><a href=mailto: > </a><br><a href= > </a><br>I don't care what others say. It's only breathing that gets you through life

 

[Dreamboat]

Send me your file, Tarquine, we'll work on it. Also explain what it is you want to do. It sounds to me as if you're going about it a little more difficultly than you need to.<br><br>In other words, have the month-end sheet already made out. Have a sheet with current values on it. The month-end sheet should be linked to the current values cells. <p> <br><a href=mailto: dreamboat@nni.com> dreamboat@nni.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>