| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possilbe easy question
here is my "formula"
='PSID Details'!C45 My question is how do I get it to where if I drag the formula down it will go like ='PSID Details'!D45 ='PSID Details'!E45 ='PSID Details'!F45 ='PSID Details'!G45 Thanks for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Possilbe easy question
Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3))) If this post helps click Yes --------------- Jacob Skaria "Confusicous" wrote: here is my "formula" ='PSID Details'!C45 My question is how do I get it to where if I drag the formula down it will go like ='PSID Details'!D45 ='PSID Details'!E45 ='PSID Details'!F45 ='PSID Details'!G45 Thanks for the help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Possilbe easy question
Thanks! I appreciate it
"Jacob Skaria" wrote: Try the below which starts from C45 =INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3))) If this post helps click Yes --------------- Jacob Skaria "Confusicous" wrote: here is my "formula" ='PSID Details'!C45 My question is how do I get it to where if I drag the formula down it will go like ='PSID Details'!D45 ='PSID Details'!E45 ='PSID Details'!F45 ='PSID Details'!G45 Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy question | Excel Discussion (Misc queries) | |||
| REALLY easy question | Excel Worksheet Functions | |||
| Easy Question | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| easy question .... i think | Excel Discussion (Misc queries) | |||
Linear Mode
