| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference autofill.
I am pulling data for certain cells on another sheet. It is every 7 cell that I need from one column of about 1000 rows. When I work on a referencing the cells I am unable to properly autofill. For example I enter =i5 in a cell and =i12 below that that cell and then autofill then next cell and get =i7, instead of =i19 How can I set this up to count by sevens so when when I fill I am able to reference i5, i12, i19, ect without typing everything in by hand? Thank you. -- mtnone ------------------------------------------------------------------------ mtnone's Profile: http://www.excelforum.com/member.php...o&userid=34950 View this thread: http://www.excelforum.com/showthread...hreadid=546823 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
| More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
| Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
Threaded Mode
