Previous Topic Next Topic

List of sheet names used in one sheet

Closed
Jaz - 13 Oct 2011 à 18:58
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2011 à 09:35
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!

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Oct 2011 à 07:45
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
Jazmin
20 Oct 2011 à 03:43
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Oct 2011 à 09:35
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

Similar discussions

Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses