0

Content of cell that is in other sheet (automatic generated)

Jet Reports Historic Posts

September 23, 2013 12:00

None

Follow

hello, I'm trying to get the contents (value) of a cell that is in a sheet that is automatically generated
I'm using the formula: = "#" & "'" & $ E9 & "'" & "K9"

E9 is the name of the sheet where I want to access.
K9 is the cell whose contents I want to get.

I used the formula cell with information typed "CONTENT", but does not work.

Thanks a lot

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts September 24, 2013 12:48

  Hi Gabriel,
  
  I hope I do understand your question.
  
  What you can do is use the following formula:
  =INDIRECT(CONCATENATE("'";C15;"'!";"A1")) where
  - C15 contains the name of the sheet to refer to
  - A1 is in text the cell te refer to. Without the quotes, you can also use a reference to the value of a cell on the active sheet
  
  Instead of Concatenate you can use text-combinations with "&". Personnaly I find the formula easier to read when using concatenate.
  
  Good luck,
  Gerard