| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto fill multiple cells depending on single cell value
Sorry, correction to this line
Refers to: =OFFSET('DV-Source'!$A$1,,,COUNTA('DV-Source'!$A:$A)) It should read as: Refers to: =OFFSET(DV!$A$1,,,COUNTA(DV!$A:$A)) (Forgot to update change made to the sheetname from 'DV-Source' to 'DV') Here's a new link to the sample construct: http://www.savefile.com/files/6529637 AutoFill_multiple_cells_depending_on_single_cell_v alue_henrat_wks.xls -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
