Hi,
Every week I receive a list of leads. Something like this, were A,B,C, etc are information that I fill in manually.
Lead Code - Info 1 - Infor 2 - Info 3
1234 A B C
5678 D E F
9111 G H I
The next week I receive a similar table (in the same file but different tab) to fill information. Many of the leads are repeated from the previous week. Right now I have to copy the same info. manually from one tab to another hundred of times.
If there any formula to copy a whole row if the lead is repeated?
Thanks!
Every week I receive a list of leads. Something like this, were A,B,C, etc are information that I fill in manually.
Lead Code - Info 1 - Infor 2 - Info 3
1234 A B C
5678 D E F
9111 G H I
The next week I receive a similar table (in the same file but different tab) to fill information. Many of the leads are repeated from the previous week. Right now I have to copy the same info. manually from one tab to another hundred of times.
If there any formula to copy a whole row if the lead is repeated?
Thanks!