How to return a cell value from a sheet that is not created yet?

Closed
Posts
4
Registration date
Thursday October 22, 2015
Status
Member
Last seen
October 22, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project.

I've created a macro that generates new sheets from a list in my summary list.

Now I want to return values in cells in my summary sheet from data in these "new" future sheets.

I want my cell C9 in Summay to return the value on cell F30 in the sheet name based on the sheet list.

Unfortunately I cannot simply select the sheet and click on F30 because this sheet has not been created yet. Once I add a new name on my summary list and play the macro to generate the new sheet I want to be able to collect data from this sheet to my summary sheet.

Thanks a lot!
Wagner




2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
two possible options

1. have a hidden sheet, that links cells from sheet you want. have you sum formula refers to these cells from the hidden cell

2. have a custom sum formula create in macro that will do what you seek
Posts
4
Registration date
Thursday October 22, 2015
Status
Member
Last seen
October 22, 2015

I don't need to sum up, I just need the actual value in that cell.
Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
one option then could be use of IF and ERROR functions to handle
Posts
4
Registration date
Thursday October 22, 2015
Status
Member
Last seen
October 22, 2015

could you send me the formula please?
Posts
4
Registration date
Thursday October 22, 2015
Status
Member
Last seen
October 22, 2015

Maybe it helps...
What I need is a formula to replace 'sheet1' for example to a sheet name on a list

=Sheet1!A1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
some thing like that =IF(ISERROR(Sheet1!A1),"",IF(Sheet1!A1="","",Sheet1!A1))