Good morning everyone, I am a beginner with very little knowledge of coding, so I'm sure my question might seem quite simple to many. Here's the issue: I have two files, each with one sheet: File1 (Sheet A) and File2 (Sheet B). Both sheets have a table (Table1 for File1, Table2 for File2) with the following columns: Name, Age, Gender. The Gender column in Table2 (File2, Sheet B) has not been filled out. The goal is to copy the data from the "Gender" column in Table1 to Table2 (from green column to yellow one.
My idea was to use the "List rows in a table" function, acquire the data from Sheet A and with an "Update a row" + "Apply to each" starting from cell C1, update Sheet B with the "Gender" data from Sheet A, but it doesn't work. I understand that perhaps, I need to initialize a variable and use an array for the storage of the data from the "gender" column, but I am not sure how to proceed. I don't even know if this is correct for such a simple operation, and I am unsure about how to do it. Could you explain to me step by step what I need to do?
