Forum Discussion
Link worksheet to a row
Here is a version of the workbook in which I have run the macro, then removed it. Perhaps the formulas will give you an idea of how you could do what you want. You need to enter the formula in B2 only, then fill or copy to the right and down.
See the attached demo workbook. The Summary sheet has the addresses of the cells you want to link to listed in B1, C1, etc.
Running the Listsheets macro will create a list of sheets in column A, and then create formulas in column B, C, etc. that link to the specified cells.
You'll have to allow macros.
- Hello and thanks! Unfortunately I´m using my workcomputer which doesn´t allow me to use the macros (it shows some risk warning). 😞
Here is a version of the workbook in which I have run the macro, then removed it. Perhaps the formulas will give you an idea of how you could do what you want. You need to enter the formula in B2 only, then fill or copy to the right and down.
- Thank you! This works just the way I wanted 🙂
