hello,
i have built a separate report that seems to run on different worksheets which seems to work but only one of the sheets is using the report options how can i make sure both reports use the same options?
Thanks
Date
Votes
5 comments
-
Heather Rowe you need to look at the Jet formulas on the second sheet, and update the variables to point to the Options sheet. For example, we'll assume that Sheet1 is referencing the Options sheet correctly - and on Options you have a variable for Account - that appears in cell C2. On Sheet1, the filter for your Account will show Options!$C$2
You need to include that same reference on Sheet2 - anywhere you are filtering for Account, you need to reference Options!$C$2(of course, this is a simple explaination - and an example of where you are seeing the problem is always good to help the community solve for your specific issue).
hopefully this helps! -
Sam G HI Heather,
thanks i did that, but oddly when i hit run the dialog options box only opens for one of the sheets.
-
Heather Rowe You can't have two options boxes open for the same workbook. That's not how Options are designed to work.
If the two worksheets need to run together, and be dependent on the same variables, you need to combine all of the options to a single sheet and update your references to work from that sheet. -
Sam G Oh perfect - I reworked it and it works very well. Thanks for your help.
-
Heather Rowe glad that worked for you! :)
Please sign in to leave a comment.