Hello experts,
I am looking for auto increment or auto fill the different sheet number Sheet1, Sheet2, Sheet3........Sheet300. PLease help to get the following in aauto fill mode. BTW i am using EXCEL-2007.
<TBODY>
</TBODY>
I am looking for auto increment or auto fill the different sheet number Sheet1, Sheet2, Sheet3........Sheet300. PLease help to get the following in aauto fill mode. BTW i am using EXCEL-2007.
=Sheet1!D$6 | =Sheet1!D$9 | =Sheet1!D$15 |
=Sheet2!D$6 | =Sheet2!D$9 | =Sheet2!D$15 |
=Sheet3!D$6 | =Sheet3!D$9 | =Sheet3!D$15 |
=Sheet4!D$6 | =Sheet4!D$9 | =Sheet4!D$15 |
=Sheet5!D$6 | =Sheet5!D$9 | =Sheet5!D$15 |
=Sheet6!D$6 | =Sheet6!D$9 | =Sheet6!D$15 |
=Sheet6!D$6 | =Sheet7!D$9 | =Sheet7!D$15 |
=Sheet8!D$6 | =Sheet8!D$9 | =Sheet8!D$15 |
=Sheet9!D$6 | =Sheet9!D$9 | =Sheet9!D$15 |
=Sheet10!D$6 | =Sheet10!D$9 | =Sheet10!D$15 |
<TBODY>
</TBODY>