Enhance Excel Worksheet

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.


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

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.

Habilidades: Visual Basic

Veja mais: what is visual programming, what is visual basic programming, what is sorting data, what is data sorting, we excel, visual basic programming notes, simple landscape design, programming in excel, printed names, price of design label, price label design, excel data programming, excel c# programming, excel add in programming, excel &, design label price, enhance excel worksheet, new excel, n excel, get the label, summary table, sort excel, sales excel, price excel, landscape

Acerca do Empregador:
( 18 comentários ) Woodridge, United States

ID do Projeto: #167274