Forum Discussion
reports from multiable sheets
Using multi able sheet reporting , can a cell in a row in the report be made active so they take me to the sheet containing the reported table . hope this makes sense cheers Bill
Thank you , however I think we might be going in different directions, I am looking for the ability ,
to use a query made from multiple sheets , choose a cell on the query report which will ,, lets say hyper jump from the query to the sheet that cell originally came from , similar to what happens when using find all in search, you can choose a result and jump straight to the sheet from there ,
cheers and thanks you , any ideas ?
to use a query made from multiple sheets , choose a cell on the query report which will ,, lets say hyper jump from the query to the sheet that cell originally came from , similar to what happens when using find all in search, you can choose a result and jump straight to the sheet from there ,
cheers and thanks you , any ideas ?
Hello Bill, have you taken the trouble to look at my example document? There I have prepared a jump to another worksheet for you. If that's not it, then I don't understand the request well enough. Maybe you can create a concrete example. Then it will be easier.
- I can see what you are suggesting , however to do that , i will have to link every sheet individually, and if the report changes because of changes in the sheet , will the update report need to be re- linked.?
eg. I have a report that shows items that need purchasing , the sheets each change as the levels drop or increase from "purchase" to "not required" , if the cell value on the sheet says "purchase "it will appear in the purchase report query, every entree to a sheet changes the report at the same time
cheers