| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill reference series
Only select 1 cell when you do your drag. Otherwise, XL thinks you want to
copy that particular pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rick" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill reference series
Ugh need coffee...ignore earlier post. Your formula should be copying
correctly. Make sure the cells aren't formatted as text, and that could cause issues. Also, is calculation mode set to automatic, or manual? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Luke M" wrote: Only select 1 cell when you do your drag. Otherwise, XL thinks you want to copy that particular pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rick" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofill reference series
Cells are formatted to number. It does not sequence up on the row number.
It holds the column with $, but selecting the 1st cell in the series and dragging only paste the previous cell. If I make the 1st 3 cells sequence up like I want (='F20 survey'!$B7; ='F20 survey'!$B8, ='F20 survey'!$B9) then try to drag, it copy and paste those cells over and over "Luke M" wrote: Ugh need coffee...ignore earlier post. Your formula should be copying correctly. Make sure the cells aren't formatted as text, and that could cause issues. Also, is calculation mode set to automatic, or manual? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Luke M" wrote: Only select 1 cell when you do your drag. Otherwise, XL thinks you want to copy that particular pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rick" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
