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”
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.
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
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)
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
I've attached a screen copy of the worksheet and a zip file with the xls code.
Zip file with xls code
Sorry, the file was too large to upload. Here is a zip file containing the XLS file.
I would like to apologise to all the bidders on this project.
Our software developer has decided to build the project on our SQL Server and create a PDF rather than send download the data to Excel.
So we will not be updating the Excel project, we will cancel it. I thank you for your time and I apologise again for not completing this project.