Possilbe easy question

  • Thread starter Thread starter Confusicous
  • Start date Start date
C

Confusicous

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!
 
Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3)))

If this post helps click Yes
 
Thanks! I appreciate it

Jacob Skaria said:
Try the below which starts from C45
=INDIRECT("'PSID Details'!" & ADDRESS(45,ROW(A3)))

If this post helps click Yes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Help 5
Form/subform problems!! 0
macro help needed 2
many to many relationship 4
Help creating schedule 5
newbie ? 1
VALUE appearing (referencing blank cell) 3
VLOOKUP Difficulty 5

Back
Top