I look for a code to transfer an entire line that has reached a condition.

asked 2020-04-11 15:12:18 +0100

RudPiva gravatar image

updated 2020-04-12 16:38:55 +0100

Ex: In a sheet, I have a list of orders and when an order is fulfilled I want the line to be transferred to another sheet running a macro and, if possible, delete it from the initial sheet. C:\fakepath\15866297771646498.ods

edit retag flag offensive close merge delete

Comments

Just a hint on how to deal with problems like yours in a calc/spreadsheet fashion - see answer to question https://ask.libreoffice.org/en/question/238069/libreoffice-calc-find-and-copy-all-matching-data-in-rows/

Opaque gravatar imageOpaque ( 2020-04-12 11:41:11 +0100 )edit

Thaks for this information, but I would like an automatic process.

RudPiva gravatar imageRudPiva ( 2020-04-12 16:51:53 +0100 )edit

This is not a question of automatic or not, but a matter of how you create various tables from some fundamental data base. Thus I'd have 3 sheets:
1.) All orders
2.) Fulfilled orders created from 1.) using filters 3.) Backlog orders created from 1.) - 2.) using filters

Whether you apply your filters by an macro or manually is another question, but just don't support the idea of copying content via macro from one sheet into another

Opaque gravatar imageOpaque ( 2020-04-12 17:16:47 +0100 )edit

I understand your point of view (I currently do this manually, Cut and copy selected line). But I have many requests to fulfill and others will be requested, so I would like to transfer completed orders to another spreadsheet and exclude them from the first one. Like this, I would have a clear view of what I still have to attend to.

RudPiva gravatar imageRudPiva ( 2020-04-12 18:21:19 +0100 )edit