deleting rows after date

[vibehappy]

hey everybody...

i've got a bit of a stumper and i would *really* appreciate some help. i want to make a weekly budget. it'll show when bills are due, how much, and how it compares to income, etc.

i want to have a year's worth of weeks on the worksheet, and i want each week to disappear once the week is over. and i want it to be automatic. i have been looking and looking and looking and *cannot* find the answer.

help?!?

thank you!
ashe

 

[mbb4331]

How about a sheet for each week, and when you open the workbook, Excel would use the current date to determine which sheet to make visible?

 

[vibehappy]

that's not a bad idea, and definitely worth considering if i can't find another option. i'm attempting to replicate something i've seen done before, so i *know* it can be done...i wonder if it's too obscure for anybody to really know how to do...? thanks for the reply!