software

I am trying to take the sheetname from a cell to print the content of the
mentioned sheetname in the another cell. the cell id will be same for
different sheet name.

Example: we have four sheets named sheet1, sheet2, sheet3 amp; sheet4 in the
same workbook. in this sheet1 to sheet3 is having the same template but with
differnt values. I wish to creat the summary of the above one or two or three
sheets in the Sheet4. so I wish to take the sheetname as input from the user
in sheet4 which will help me to access the concerned cells (cell id of
different items are constant for all the templates).

Hope you understood the problem, kindly give me a sollution for this.

suppose B6 of sheet1 has entry
sheet2

if you have a code
Worksheets(Range(quot;B6quot;).Value).Activate
in a macro and run it
it will activate sheet2
you get the hang of it and use it in your macroquot;Kanagabalanquot; gt; wrote in message
...
gt;I am trying to take the sheetname from a cell to print the content of the
gt; mentioned sheetname in the another cell. the cell id will be same for
gt; different sheet name.
gt;
gt; Example: we have four sheets named sheet1, sheet2, sheet3 amp; sheet4 in the
gt; same workbook. in this sheet1 to sheet3 is having the same template but
gt; with
gt; differnt values. I wish to creat the summary of the above one or two or
gt; three
gt; sheets in the Sheet4. so I wish to take the sheetname as input from the
gt; user
gt; in sheet4 which will help me to access the concerned cells (cell id of
gt; different items are constant for all the templates).
gt;
gt; Hope you understood the problem, kindly give me a sollution for this.
Assuming the name of the sheet is entered in a cell named quot;SheetNamequot;, the
following will return the contents of cell A1 of that sheet..........

=INDIRECT(SheetNameamp;quot;!A1quot;)

hth
Vaya con Dios,
Chuck, CABGx3

quot;Kanagabalanquot; wrote:

gt; I am trying to take the sheetname from a cell to print the content of the
gt; mentioned sheetname in the another cell. the cell id will be same for
gt; different sheet name.
gt;
gt; Example: we have four sheets named sheet1, sheet2, sheet3 amp; sheet4 in the
gt; same workbook. in this sheet1 to sheet3 is having the same template but with
gt; differnt values. I wish to creat the summary of the above one or two or three
gt; sheets in the Sheet4. so I wish to take the sheetname as input from the user
gt; in sheet4 which will help me to access the concerned cells (cell id of
gt; different items are constant for all the templates).
gt;
gt; Hope you understood the problem, kindly give me a sollution for this.

This is what i exactly needed for my excel programming. Thanks a lot.

GKB
Chennai

quot;CLRquot; wrote:

gt; Assuming the name of the sheet is entered in a cell named quot;SheetNamequot;, the
gt; following will return the contents of cell A1 of that sheet..........
gt;
gt; =INDIRECT(SheetNameamp;quot;!A1quot;)
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Kanagabalanquot; wrote:
gt;
gt; gt; I am trying to take the sheetname from a cell to print the content of the
gt; gt; mentioned sheetname in the another cell. the cell id will be same for
gt; gt; different sheet name.
gt; gt;
gt; gt; Example: we have four sheets named sheet1, sheet2, sheet3 amp; sheet4 in the
gt; gt; same workbook. in this sheet1 to sheet3 is having the same template but with
gt; gt; differnt values. I wish to creat the summary of the above one or two or three
gt; gt; sheets in the Sheet4. so I wish to take the sheetname as input from the user
gt; gt; in sheet4 which will help me to access the concerned cells (cell id of
gt; gt; different items are constant for all the templates).
gt; gt;
gt; gt; Hope you understood the problem, kindly give me a sollution for this.

You're quite welcome......glad to be of help.........thanks for the
feedback....

Vaya con Dios,
Chuck, CABGx3quot;Kanagabalanquot; gt; wrote in message
...
gt; This is what i exactly needed for my excel programming. Thanks a lot.
gt;
gt; GKB
gt; Chennai
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Assuming the name of the sheet is entered in a cell named quot;SheetNamequot;,
the
gt; gt; following will return the contents of cell A1 of that sheet..........
gt; gt;
gt; gt; =INDIRECT(SheetNameamp;quot;!A1quot;)
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Kanagabalanquot; wrote:
gt; gt;
gt; gt; gt; I am trying to take the sheetname from a cell to print the content of
the
gt; gt; gt; mentioned sheetname in the another cell. the cell id will be same for
gt; gt; gt; different sheet name.
gt; gt; gt;
gt; gt; gt; Example: we have four sheets named sheet1, sheet2, sheet3 amp; sheet4 in
the
gt; gt; gt; same workbook. in this sheet1 to sheet3 is having the same template
but with
gt; gt; gt; differnt values. I wish to creat the summary of the above one or two
or three
gt; gt; gt; sheets in the Sheet4. so I wish to take the sheetname as input from
the user
gt; gt; gt; in sheet4 which will help me to access the concerned cells (cell id of
gt; gt; gt; different items are constant for all the templates).
gt; gt; gt;
gt; gt; gt; Hope you understood the problem, kindly give me a sollution for this.