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

Habilidades: Visual Basic

Ver mais: we excel, visual basic programming notes, simple landscape design, printed names, price design label, price label design, excel data programming, excel add programming, design label price, enhance excel worksheet, new excel, n excel, get label, summary table, sort excel, sales excel, price excel, Landscape, hide price, excel design, excel data sorting, border, little code change, excel sort date, excel contains

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

ID do Projeto: #167274