Hello!
I have a question. I have 2 tables in two different sheets. The first table it is like my data base, where all my information is going to be stored.
The second table, it is basically a copy of the first one, but this second one is going to show only the records that I am looking for.
this is my table 1
this is table 2
as you can see, table 2 displays all the names that are repeated, to get that information I was using a vlookup.
Now the question. I don't know if it is possible or how to achive it. Whithout visual basic or macros. Is it posible, once I find the information in table 2, edit the registers from there? the thing is, if I click in the cell, the formula appears, so I can't edit the information. Is there any way to edit the information that I find with a vlook up, and that that update that I made can be visible in table 1?
Thank you
I have a question. I have 2 tables in two different sheets. The first table it is like my data base, where all my information is going to be stored.
The second table, it is basically a copy of the first one, but this second one is going to show only the records that I am looking for.
this is my table 1
this is table 2
as you can see, table 2 displays all the names that are repeated, to get that information I was using a vlookup.
Now the question. I don't know if it is possible or how to achive it. Whithout visual basic or macros. Is it posible, once I find the information in table 2, edit the registers from there? the thing is, if I click in the cell, the formula appears, so I can't edit the information. Is there any way to edit the information that I find with a vlook up, and that that update that I made can be visible in table 1?
Thank you
