door schedule worksheet re-ordering (numbers)

[Michelle]

Try as I might I cannot re-order the door schedule I created (from the door record) to read in a numerical order. Is there a way to correct this other than cut and paste?

Also can they be updated or must you always just replace them?

[Pat Stanford]

In the Worksheet, there is a SUM icon at the top. Select the header row of the schedule and then drag the SUM icon to the column(s) that you want to sort by.

You can edit the schedule as much as you want. Select a cell in the header row and you can see the formula for the cells in that column. CHange it as you need.

To add addtional columns, click on the little black triangle at the top left of the worksheet.

If you need to change the doors shown in the schedule (only doors on first floor for example), click and hold on the row header (e.g. 2) for the database and select the Edit Criteria option.

Pat