Help with OpenOffice Calc formula or macro

[krasi098]

Hello,

I'm trying to make a formula or macro for the following purpose:

Its something like To Do list depending on date.
I want if the date in column B in sheet 1 is today date, all rows that is with this date to be copied to sheet 2.

Something like that : If Sheet1.B1=today(), copy row 1 to sheet 2

I've attached my test file to take a look.
http://www.mediafire.com/file/6z66qydmt ... 282%29.ods

Please help with this issue.



Regards,

[karolus]

hallo


̣→Data→Filter→Standardfilter … with the obvious settings, and targetrange [x]→todo.A1

[krasi098]

Hello,

where is "targetrange [x]" in "filter options ?

I want this to be an automated process... I'm not sure if the filter will do this.

I'm new in OO, please specify the steps.

Thanks a lot!