| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill reference series
How can I make the following cell reference drag and fill up to B66
='F20 survey'!$B7 ='F20 survey'!$B8 ='F20 survey'!$B9 .... ='F20 survey'!$B66 When I autofill or drag and fill it only paste/fills the 1st three over and over |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill series with keyboard | Excel Discussion (Misc queries) | |||
| how can i use series autofill when I use autofilter? | Excel Discussion (Misc queries) | |||
| autofill series | Excel Worksheet Functions | |||
| Autofill a series | Excel Worksheet Functions | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
