• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy sheet address to a formula

Matt_Straya

Member
Hi, instead of typing out each formula I want to copy a list of 40 rows referencing to each sheet. I have attached the example. Any ideas?
 

Attachments

  • Book1.xlsx
    18.8 KB · Views: 6
If the first occurence on the formula is in row 1 try =IFERROR(INDIRECT("'EMP"&row()+3&"'!$K$2","")
Otherwise adapt the ROW().. part to the row you are starting in.
For example if you start in row 10 use row()-6, etc...
 
If the first occurence on the formula is in row 1 try =IFERROR(INDIRECT("'EMP"&row()+3&"'!$K$2","")
Otherwise adapt the ROW().. part to the row you are starting in.
For example if you start in row 10 use row()-6, etc...
Thanks Pecoflyer! works a treat using this: =IFERROR(INDIRECT("'EMP"&ROW()-10&"'!$K$2"),"")
 
You're welcome
Be careful with IFERROR, it hides ALL errors, what might not be what you want...
 
Back
Top