Table sorting

[markyrowland]

Hi Guys,

I am currently making a spreadsheet for loaned devices and am sturggling quite badly on how to make it.
I want one of the sheets to show a table that takes the information from the main sheet and then sorts through it to find any loans that are to come back to me in the next week.

I have done this before on a similar sheet but it was much easier, on an earlier sheet i didnt have this problem because i was only able to loan a device once a day, therefore using the date as the ID and only using an extremely easy Vlookup.

The problem with this now is that quite a few loans can now be made and i now dont have an easy way to find all the upcoming loans.

I have only ever done excel in A-Levels before this so my knowledge is pretty limited, so forgive me if im being an idiot!

 

[bschwartz]

Simplest way would probably be a PivotTable.

From anywhere on the table, go to Insert --> PivotTable --> OK. This will create a PivotTable on a new worksheet. When selected on one of the cells in the PivotTable, a dialog box will open on the right. Select all of the relevant fields that you need to see. Go to the design tab on top, and change the option for Report Layout to Tabular Form.

On the header for Due Date, select the dropdown arrow, go to Date Filters --> This week. Every time you add data and want to see the items due this week, you will need to select anywhere on the PivotTable, go to the Options tab on top, and select Refresh.

 

[markyrowland]

Knew it would be easier than anticipated...

Is there a possible way of getting rid of the sum totals at the bottom of the table?