Excel Dashboard Help - Events list

[mwdawg721]

I have one worksheet that has a list of events for a three-month period. One column in this sheet displays the WEEKNUM for each event. In a separate sheet, I want to display only events with a WEEKNUM for this week. Do you know of a formula I can use (perhaps OFFSET?)??

 

[Smitty]

Welcome to the Board!

You could probably use a Pivot Table (the helpfile has a good tutorial).

You could also use Auto-Filter, but that will leave your data on the same sheet (there are ways to move/copy it though).

HTH,