G
Guest
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 & 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.
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 & 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.