Transferring rows to new sheets with sorting by dates


Task: transfer rows to new sheets, each sheet is one date which is specified in column A.

This is an example of a source document with a table:

And this is roughly how the document should look like after applying the macro:

Note 1: without using Conditional Formatting, only the Macro is needed.

Note 2: if possible without entering dates into the Macro.

Note 3: this table is just an example, the real table has hundreds of rows and dozens of columns, but always in column A is the date in the format as in the example.

Note 4: is using LibreOffice on Windows 8.1 if it matters.

Table before applying Macro (22.7 KB)
Table after applying Macro (13.4 KB)

Thanks in advance.

Wow, how well disguised! Almost deceived me…


No, I won’t give you a solution.

I think this is not the place to show your prejudices, you could just ignore it and not make political sh*t. Especially when you don’t know anything about the person and when in your country a language so disgusting to you is used everyday by a huge number of people, including heroes who defend you.
Have a good one.

Слава Україні.

@JohnSUN Thanks for the tip on resolving this question, I adapted the code to my needs and it works very good.

All the best to you. :pray:

Link to the solution