Macro to Move Value based on Value in another cell

English
,
#1

New to Macros, really need some help.

Can I use a macro to Cut A2/A4 and Move the value to A3/A5 based on E2/E4 being “TRUE”, and then Delete the entire Row with the “TRUE” value?

UK US Artist Title Duplicates
|4||Bobby Darin|Dream Lover|TRUE|
||6|Bobby Darin|Dream Lover|FALSE|
|11||Bobby Darin|Mack The Knife|TRUE|
||2|Bobby Darin|Mack The Knife|FALSE|

Any help greatly appreciated

#2

could YOU upload a real example.ods with the data before the action and the data which YOU would expect after the action?? ( if you edit your post there is an ⇑ -upload-button in the middle of the toolbar )

1 Like
#3
  • Filter by True
  • Delete entire rows
  • Remove filter
#4

If i understand correctly, there is also the need to replace »6« by »4« and »2« by »11« ?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.