I need help with google spreadsheets. 

Lets say in sheet 1, i call it "capture". In capture, I'm inserting some data, each row has 6 columns i must fill with a 7th column with a dropdown option. One of the options is "pass to sheet 2"

When i select that dropdown and all the data is filled i would like to move that data of the row to sheet 2 (called "preparar") and delete the row from capture sheet
You can achieve this using Google Apps Script. Here's a step-by-step guide to help you accomplish this:

**Step 1: Create a dropdown list in the 7th column of the "Capture" sheet**

* Select the entire 7th column (G:G) in the "Capture" sheet.
* Go to the "Data" menu, then click on "Data validation".
* Select "List from a range" and enter the options you want to display in the dropdown, including "Pass to sheet 2".
* Click "Save".

**Step 2: Create a script to move data to "Preparar" sheet and delete the row**

* Open your Google Spreadsheet.
* Click on "Tools" in the menu, then select "Script editor". This will open the Google Apps Script editor.
* Delete any existing code in the editor, and paste the following script:
```javascript
function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var range = e.range;
  
  // Check if the edited cell is in the 7th column of the "Capture" sheet
  if (sheet.getName() == "Capture" && range.getColumn() == 7) {
    var value = e.value;
    if (value == "Pass to sheet 2") {
      var row = range.getRow();
      var data = sheet.getRange(row, 1, 1, 6).getValues()[0];
      
     
You can use the INDIRECT function to move data from one sheet to another. For example, you could use the formula =INDIRECT("Sheet2!A2") to move the data from row 2 of sheet 1 to row 2 of sheet 2. This will replace the contents of the row with the data from the previous sheet.