| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fill Query
I have a fill right problem, where I want excel to give me the result of the cell below. In a Horizontal table, with years along the columns, I have the following in B1 'Sheet 2'!A1 + 'Sheet 2'!A100 + 'Sheet 2'!A200 Is there a way to fill right, so I get the result in B2 'Sheet 2'!A2 + 'Sheet 2'!A101 + 'Sheet 2'!A201 instead of B1,B100 and B200 Any help appreciated. Hywel Manchester UK -- Hywel ------------------------------------------------------------------------ Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824 View this thread: http://www.excelforum.com/showthread...hreadid=483426 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| fill handle + query | Excel Worksheet Functions | |||
| Web Query Help... | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Threaded Mode
