Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft Excel _ Water Read Sheets

Posted by: Kruzer Feb 17 2020, 02:28 PM

Version = Office 365

At the beginning of each month a water read sheet is generated for staff to read meters on various properties we manage. The current manager would like to have one sheet to manage all the readings and be able to print one sheet for each property for staff to record new readings. I am trying to come up with a simple way to do this.

1) Is it possible to create a custom filter that is part of the sheet used for headings/titles? I know the excel filter function would work but then the property name would have to be manually typed in or selected from drop-down list for the sheet heading/title section. I have been able to create a drop-down list with unique values but need to be able to set this drop-down list as the filter criteria as well. The property column is not included within the print area.

2) Is it possible to make a column visible based on a selection? For example, we show the previous month's readings to the left of the column where the staff write in the current readings, e.g. Dec 2019 to left of column for current reading being obtained for Jan 2020. ( 24.81K ): 5

Posted by: RJD Feb 17 2020, 08:32 PM

Hi: The way your example is structured, and the way you described the operation/requirement, seems more like an Access application rather than Excel. Have you thought about using Access for this instead? Just curious ...


Posted by: Kruzer Feb 18 2020, 07:58 PM

I have and it would be my preference. The data from these sheets will be inputted into other property spreadsheets with calculations, etc. specific to that property. I may suggest going with Access. I'll post if I need more assistance or if I can come up with another way to handle this.

Thank you.

Posted by: RJD Feb 18 2020, 08:09 PM