• 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.

Urgent help

P

Prashant Kenia

New Member
how do I increase the sheet number, but keep the same cell reference in a formula.
I have 600 worksheets in different files. I need to get from each sheet data from cell b6 and h6 on a single sheet one below the other. I have tried ='sheet'!$b$6 but how to increase the sheet number.
 
@Prashant Kenia

Welcome Chandoo.org Forum, Glad you are here

as a new member first i would like to remember you please read before post any question in this forum about the forum rules from this link http://chandoo.org/forum/forums/new-users-please-start-here.14/ and most important is this http://chandoo.org/forum/threads/new-users-please-read.294/

this is a 24 X 7 and all of the forum members are through out the world wide and they are busy with their personal work and this is week end. If you need any Urgent Replays then you can search in Google there is lot of sites to help you for payment

Hope you Understand. Please post a new thread with the same problem but change the Title may be one of our Ninja's can lock this thread or they can change the title with your request

to start a new thread please click here http://chandoo.org/forum/forums/ask-an-excel-question/ and select the "Post New Thread"

Thanks

SP
 
Hi

have a look at the attached file for an example of the INDIRECT function.
 

Attachments

  • IndirectSample.xlsx
    8.7 KB · Views: 4
Did you adapt or adjust the formula to suit your data/setup?. If you upload a file you will get the exact formula
 
Have a look at the uploaded file, you will see that I have used an extra column A for the sheet names.

cheers

kanti
 

Attachments

  • FORM AB1 - Copy.xls
    308.5 KB · Views: 8
You must log in or register to reply here.
Back
Top