Looking for a template or help with a template using sheets.

[Red Guardian]

Hello everyone,
This is my first post and probably will be my most confusing lol,
I am creating a excel document for a college graphic arts class.
Bascially I would be entering alot of projects with due dates for everyone
of them and I would call this sheet "inner class"
On a second sheet I would do the same and call it "outer class"

So, I would like to be able to have a third sheet that would automatically
grab projects due in the week and place them on there. Or projects due in two
weeks and so on.

Do you think its possible to generate this easily? lol
The most programming knowledge I have is to sum a whole column (dont laugh)

Any help would be greatly appreciated!

Thank you,
Angel

 

[OssieMac]

Hi Angel,

Since you say that you have very limited knowledge of xl then might I
suggest that you alter the way that you set up your data. Try setting up all
the data on one worksheet with column headers for Due Date and Class plus any
others you want.

Under Due Date, simply enter the due date and under Class enter either Inner
or Outer.

Then set up Auto Filter. If your version of xl is 2007 then do this by
selecting menu item Data then click on Filter (the big funnel on the ribbon).
On earlier versions of xl select menu item Data then Filter->AutoFilter. Then
simply click on the drop down arrows against the column headers and select
the data to display. You can either use an individual filter or multiple
filters and I think that this will achieve the outcome you desire.

Hope this helps you because it is a very easy way to filter and view data.

Regards,

OssieMac