| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks so much Bill....your information is very helpful.
"bill k" wrote: In general excel formula's do not "drop into" they "get from" So, On sheet 5 in the cell where you would like to see the result from sheet 4, enter the = sign click onto sheet 4 cell and push enter. You can extend the formula on sheet 5. Click onto the right hand bottom corner of the cell.... the mouse pointer will have changed to a + sign.... and drag down as far as necessary. -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=472760 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
| automatically drop data to next line | Excel Discussion (Misc queries) | |||
| formulas for drop down menus | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Hybrid Mode
