Previous Topic Next Topic

List of sheet names used in one sheet

Closed
Jaz - Oct 13, 2011 at 06:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2011 at 09:35 AM
Hello,

I have been given a model with 53 sheets, I want to check if the formulas are ok. I was thinking to make a flowchart or matrix to be able to understand it better. Is there a way to get a flowchart/matrix of all the sheets or at least is there a way to create a list of all the sheet names that are used in an specific sheet?

Many thanks!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 15, 2011 at 07:45 AM
so are you trying to see what sheets are being refered in a formula ? If you just want to see the formulas, then you can use CONTROL and ~ pressed at same time to show or hide formula
0
Jazmin
Oct 20, 2011 at 03:43 AM
Hi, I am trying to get a list of all the sheets that are bringing data to a specific sheet. It is only one workbook. Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 20, 2011 at 09:35 AM
If you are just trying to see if formulas are right, then a macro can write out to a text file or to a sheet all the formula are being used.

If you are trying to see what sheets are being used in the formula, again a macro would be needed. Other way that might work would be if you delete one by one sheets, if the sheet is being used, the formula would error out

I am not clear on your intent, so dont know if these solutions would fit your requirement
0

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses