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

Sheet Reference

M

maheshkasera

New Member
Plz help me in feeding a formula from which i can be able to make a global reference with multiple sheets e.g. I have Tweleve sheets with some data and A master sheet in which i want to give a referenceof sheet name( like sheet1) from which the date can be filled from desired sheet.
 
Maheshkasera


Firstly, Welcome to the Chandoo.org forums.


Without much detail it is difficult to assist you very much


You can retrieve a value from another sheet using a formula like:

Code: 
=Sheet1!A1


or Sum values from multiple sheets with:

=SUM(Sheet1:Sheet10!A1:D10)


adjust ranges to suit


If you want more assistance do you have a sample file you can upload

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
I HAVE 12 SHEETS AND 1 MASTER SHEET IN A FILE. IN MASTER SHEET I WANT THE DATA OF DESIRED ONE SHEET EITHER OF 12 WITH REFERENCE GIVEN IN A CELL. e.g. sheet names are 1 to 12 and in master sheet i want to pick the data of sheet1 with a single reference given in master sheet.
 
To include a variable in the Reference to another sheet you can use the Indirect() function:

=INDIRECT("Sheet"&C1&"!A2")

Will return the value from Cell A2 from the worksheet SheetC1

where C1 contains the value 1 to 12
 
You must log in or register to reply here.
Back
Top