I have a document with a series of data tables that are 13 columns wide; they have numbers, dates and percentages. Each employee has his/her own sheet with his/her own data.
I currently have a canned report within the same document that can pull data from each employee’s own sheet to produce a personalized report. For some of the data types, the report provides a summary for the four weeks (current week plus three previous weeks). Making the various formulae work is not a problem, even though some of the current formulae look more like spaghetti code of old.
I’ve been asked to reconfigure the report to make it more flexible, to enable a more targeted report for different employees who might not have the same data types in their particular reports (TMI?). I’ve figured out how to make a new report get and apply information in a nice variety of ways using drop-down lists. That’s going to be a great help; here is the “but” part of the request.
Is there a way to make the row height dynamic—self-sizing according to content?
As an example, I have one item that has a drop-down list with five items in it. Three of the items will occupy only one normal row; no problems there. One of the items is long enough that it will wrap and become two rows, and one is long enough that it will wrap and take up four rows. I know how to manually resize the rows, but if I can “teach” the sheet to resize itself in accordance with the cell’s content, I will have a lot of happy report creators.
Second thing on my wish list is to get the report to reset itself back to the basic set-up when I change employees. I would love to have an eloquent solution for this so that the end-users will not have to fight with large gaps and row resizing for each report to be generated.
Each report is run separately because we need to be able to input at least one customized paragraph to address specific plus or minus situations for each individual based on their work paths, as well as positive or negative results that need to be addressed.
Thanks in advance.
--
DeanZF
I currently have a canned report within the same document that can pull data from each employee’s own sheet to produce a personalized report. For some of the data types, the report provides a summary for the four weeks (current week plus three previous weeks). Making the various formulae work is not a problem, even though some of the current formulae look more like spaghetti code of old.
I’ve been asked to reconfigure the report to make it more flexible, to enable a more targeted report for different employees who might not have the same data types in their particular reports (TMI?). I’ve figured out how to make a new report get and apply information in a nice variety of ways using drop-down lists. That’s going to be a great help; here is the “but” part of the request.
Is there a way to make the row height dynamic—self-sizing according to content?
As an example, I have one item that has a drop-down list with five items in it. Three of the items will occupy only one normal row; no problems there. One of the items is long enough that it will wrap and become two rows, and one is long enough that it will wrap and take up four rows. I know how to manually resize the rows, but if I can “teach” the sheet to resize itself in accordance with the cell’s content, I will have a lot of happy report creators.
Second thing on my wish list is to get the report to reset itself back to the basic set-up when I change employees. I would love to have an eloquent solution for this so that the end-users will not have to fight with large gaps and row resizing for each report to be generated.
Each report is run separately because we need to be able to input at least one customized paragraph to address specific plus or minus situations for each individual based on their work paths, as well as positive or negative results that need to be addressed.
Thanks in advance.
--
DeanZF