发起问题

vanek 的档案 - 活动

2020-12-26 15:31:41 +0200 作最佳回答 move rows that match condition to different sheet with macro

Hi,

I've got a calc sheet of data with date columns. Each day the sheet grows with one row and I need to put the last 30 days data on a chart. Since named ranges and functions as data source for charts are unsupported, I'm not quite sure how to achieve this. I want to avoid manual deletion of rows, or modifying the graph data source field daily.

Is there a way to move rows that are older than 30 days (column A is ISO format date, like 2018-12-31) to a different sheet? I don't want to copy them, I want to move them completely - I guess that way I can keep 30 days of data presented.

I never tried macro in excel/calc so not sure how to do it. Or if named ranges can be achieved for charts, please do let me know.

Thanks!

2020-12-26 15:31:35 +0200 获得奖牌  自学者 (来源)
2020-12-26 15:31:35 +0200 获得奖牌  老师 (来源)
2020-03-02 14:54:37 +0200 获得奖牌  著名问题 (来源)
2019-11-04 19:56:47 +0200 获得奖牌  热门的问题 (来源)
2019-11-02 06:54:35 +0200 获得奖牌  受欢迎的问题 (来源)