Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using MS Query to import external data. The number of rows imported
changes (inceases/decreases) based on user defined criteria. I import into columns A-D but have a many columns linking to the data using formulas In excel 97-2003 there was a useful little piece of functionality that allowed you to fill adjacent formulas so as the extrnal data range expanded/contracted the adjacent formuals and hence named rnages would also do the same. Does the same functionality exist in Excel 2007. I can't find it anywhere. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill down formulas in adjacent columns | Excel Discussion (Misc queries) | |||
Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
Speed fill function for MS Ecel 2007 (Beta) | Excel Worksheet Functions | |||
How do i fill the adjacent cell formulas in user form when i press | Excel Discussion (Misc queries) | |||
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions |