| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I use fill hand to copy the fomula in this case?
Here is my fomula:
B1: =sheet2!A1 B2: =sheet2!A4 B3: =sheet2!A7 B4: =sheet2!A11 ......... Is it possible to use fill handle to copy the fomula automatically in my case?, If so, how? Thanks. Sabrina |
|
#2
|
|||
|
|||
|
I assume that B4 should read = sheet2!A10 with a help column in sheet1 enter the first function in B1 and fill that down the column enter in C column a series of 1<<2<<3<<and extend that down the column do a sort on C column delete the surplus rows Sabrina Wrote: Here is my fomula: B1: =sheet2!A1 B2: =sheet2!A4 B3: =sheet2!A7 B4: =sheet2!A11 ......... Is it possible to use fill handle to copy the fomula automatically in my case?, If so, how? Thanks. Sabrina -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=400604 |
|
#3
|
|||
|
|||
|
Thanx, Bill.
Sabrina "bill k" wrote: I assume that B4 should read = sheet2!A10 with a help column in sheet1 enter the first function in B1 and fill that down the column enter in C column a series of 1<<2<<3<<and extend that down the column do a sort on C column delete the surplus rows Sabrina Wrote: Here is my fomula: B1: =sheet2!A1 B2: =sheet2!A4 B3: =sheet2!A7 B4: =sheet2!A11 ......... Is it possible to use fill handle to copy the fomula automatically in my case?, If so, how? Thanks. Sabrina -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=400604 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| To copy fomula | Excel Worksheet Functions | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
| 3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions | |||
Linear Mode
