ProgramadorJunior's questions

Hello, I hope you can help me with the following, I have a "transaction" table in "Sheet1" which I feed with data that I have in "Sheet2" the idea is to copy the range of data from Sheet2 and paste it just below the table in my Sheet1. When trying to do it, it only manages to paste the first row but it fails when it is more than one row of data since it only continues to paste a single row. I appreciate help me. I show what I'm wearing:

Dim ws As Worksheet
Dim newrow As ListRow
Dim Text1 As String
Dim Text2 As String
Dim Text3 As String



Set ws = ActiveSheet
Set newrow = ws.ListObjects("transaccion").ListRows.Add

FinalRow = Cells(Rows.Count, 1).End(xlUp).Row


With newrow


Text1 = Worksheets("Hoja2").Range("a2").Value
Text2 = Worksheets("Hoja2").Range("b2").Value
Text3 = Worksheets("Hoja2").Range("c2").Value


  .Range(1) = Text1
  .Range(2) = Text2
  .Range(3) = Text3


  
End With
 


End Sub

Could you please help me what is the error in the following php code to update a record where the mail is taken from the record in the database... when executing it, I get the automatic error "noUpdate". I appreciate your help so that the sentence is executed correctly and take "updates". here is the code of my script:

<?php
$hostname_localhost="mysql.webcindario.com";
$database_localhost="android";
$username_localhost="android";
$password_localhost="0000";

$conexion=mysqli_connect($hostname_localhost,$username_localhost,$password_localhost,$database_localhost);

    $nombre = $_POST["nombre"];
    $correo = $_POST["correo"];
    $telefono = $_POST["telefono"];
    $direccion = $_POST["direccion"];
    $clave = $_POST["clave"];
    $ciudad = $_POST["ciudad"];


    $sql="UPDATE registro SET nombre_apellido= ? , correo= ?, telefono=?, direccion=?, clave=? , ciudad=? WHERE correo=?";
    $stm=$conexion->prepare($sql);
    $stm->bind_param('ssssi',$nombre,$correo,$telefono,$direccion,$clave,$ciudad);

    if($stm->execute()){
        echo "actualiza";
    }else{
        echo "noActualiza";
    }
    mysqli_close($conexion);
?>