We have a nice, little Excel worksheet to sort, display and print data from a text file. We would like to make some changes, remove some columns, add some new fields and fix a couple of bugs.
Simple Design Changes
Make the office name dropdown about 30% wider, not enough of the name shows. Try to get the page to fit in a Portrait page layout (rather than Landscape. In the summary section at the bottom, change the label “Realtor Summary” to “Client Summary”
Printed Versions
On the printed version, in the header, hide the box that contains the Detail File name, and hide the background border that was behind the buttons.
Add New Header Fields
Add a comments field that can be entered once and then it will display on all the following pages, this should be around 100 characters.
Sorting
Sort the table data in the columns: by User Name and then by Address and then by Date. (Note: we may just want to sort these values when we build the query)
Change Columns – Add and Delete
Delete the Price and MLS# columns, they are not needed
Add a Notes column to the right column of the table
Discount Calculations
We should apply the discount to the price before we calculate the Sales Price. (Note: we may want to calculate the Sales value when we build the query)
Programming Bugs
On certain office names, there is a bug; it displays an error message and the line of code. Sometimes the data in the table on the screen display does not match what is seen when the page is actually printed