Forum Discussion
Solved
Locking reference to another worksheet
Hello, I'm setting up a home-made bibliography data system in Excel to use for my PhD dissertation since I can't find anything useful online. I have set up separate, identical, data entry wor...
First, select the table, and set its number format to General.
In A7:
=IFERROR(INDIRECT("'Bibl. "&ROW()-6&"'!C6")&"","")
In B7:
=IFERROR(INDIRECT("'Bibl. "&ROW()-6&"'!G6")&"","")
etc.
First, select the table, and set its number format to General.
In A7:
=IFERROR(INDIRECT("'Bibl. "&ROW()-6&"'!C6")&"","")
In B7:
=IFERROR(INDIRECT("'Bibl. "&ROW()-6&"'!G6")&"","")
etc.