| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to transfer a sum from one spredsheet to another
I have a list of various food in Sheet!1 A, and the calories are listed in
colomn B in Sheet!1. I want to have the calories transfered to Sheet!2, so that if i write banana in Sheet!2 A1, the number of calories from Sheet!1 B3(wich is written next to "banana" in A3), will appear. And if I then write blueberries instead, I would like the calorieno. for blueberries, wich again comes from Sheet!1 column B Is that possible - and if, then how. Therese |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer data from multiple worksheets | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) | |||
| How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
| HOW TO TRANSFER AUTOCORRECT DICTIONARY TO NEW COMPUTER?? | Setting up and Configuration of Excel | |||
Threaded Mode
