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

Closed
wagnercardozo Posts 4 Registration date Thursday October 22, 2015 Status Member Last seen October 22, 2015 - Oct 22, 2015 at 12:12 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 22, 2015 at 12:57 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 22, 2015 at 12:21 PM
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
0
wagnercardozo Posts 4 Registration date Thursday October 22, 2015 Status Member Last seen October 22, 2015
Oct 22, 2015 at 12:25 PM
I don't need to sum up, I just need the actual value in that cell.
Thanks
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 22, 2015 at 12:32 PM
one option then could be use of IF and ERROR functions to handle
0
wagnercardozo Posts 4 Registration date Thursday October 22, 2015 Status Member Last seen October 22, 2015
Oct 22, 2015 at 12:35 PM
could you send me the formula please?
0
wagnercardozo Posts 4 Registration date Thursday October 22, 2015 Status Member Last seen October 22, 2015
Oct 22, 2015 at 12:47 PM
Maybe it helps...
What I need is a formula to replace 'sheet1' for example to a sheet name on a list

=Sheet1!A1
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 22, 2015 at 12:57 PM
some thing like that =IF(ISERROR(Sheet1!A1),"",IF(Sheet1!A1="","",Sheet1!A1))
0