Hello,
I have attached one dummy file with the problem and wanted result. I have a long list with different materials and price changes, and I need to sort them as it is in file. Copy all data for one material (sometimes only one row, and sometimes 5 or 10 rows) and paste it at other sheet. Then sort data by date (descending). Last date comes first and all data from that row follows, Then it comes next date with data.
Then I take second material and paste all data into other sheet with one empty row between last material. Sort it same way and jump to next.
I tried to solve it by myself but I am stuck![]()
Thanks in advance.
Bookmarks