Hi
I have used excel spreadsheets for very basic calculations (+,-,x and /, %ages etc) so I am new and would like to ask a beginers question:
How do I use 'x' boxes to select values - for example, if I have a list of foods with nutritional data, rather than copying the rows of data into another sheet can I put a 'x' box beside it and select the data that way?
also, I have foods listed from a to z and when i select a food i need the data to appear on another worksheet - how is this done? E.g. in my 'm' list i select mustard (by ticking the box) and need the data to apear on a food log which will be on a separate sheet - kcals, fat, carbs etc
any help appreciated
thanks in advance
Andy
Bookmarks