Forum Discussion
Solved
Link worksheet to a row
Hello, Sorry for the long text 🙂 I have a workbook which has 100 worksheets. The worksheets contains data of different rooms so that the data is always in the same place/cell within the worksheet....
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.
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 🙂