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
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
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