| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy dependant validation cell
I have compiled a spreadsheet which uses the following dependant validation
formula. Is there a way to copy the validation & it's formula to all cells in that column without incrementing the source. E.g. replicate $A134 and A134 without next cell becoming $A135 and A135 etc =OFFSET(INDIRECT($A134),0,0,COUNTA(INDIRECT(A134&" Col")),1) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy dependant validation cell
Fix A134 by using the " $ " sign i.e. $A$134 in both occurrences in the formula
"martb" wrote: I have compiled a spreadsheet which uses the following dependant validation formula. Is there a way to copy the validation & it's formula to all cells in that column without incrementing the source. E.g. replicate $A134 and A134 without next cell becoming $A135 and A135 etc =OFFSET(INDIRECT($A134),0,0,COUNTA(INDIRECT(A134&" Col")),1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy value from the cell above to the cell below in a column | Excel Discussion (Misc queries) | |||
| How can I copy values from one cell in a column down to the next c | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
