cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SOLVED

Copy entire row to another sheet if value matche

sambomim
Copper Contributor

‎Oct 28 2022 08:52 AM

‎Oct 28 2022 08:52 AM

Copy entire row to another sheet if value matche

Hello guys,

I have 2 sheets, and they share one value, the customer ID, so, I need to cross the information between. Taking in consideration the Customer ID, I need to know the page URL who generated the sale.

 

What I've accomplished until now? With the the countif function I was able to see if a value from sheet 1 is also in sheet 2. What I need? If Customer ID on sheet 2 matches customer ID of sheet 1, that I need to copy the value of page URL of the row of sheet 2 to sheet 1.

 

Hoping that I was clear. Thanks in advance for all your help.


Sheet 1

Nome PacienteCustomer ID / Nº ProcessoData criação PacienteContacto PacienteEmail PacienteClinicaData ConsultaTipo ConsultaEstado da ConsultaEstado PropostaData Venda PropostaTipo PropostaValor Proposta €id_referenciador_ptPaciente KOProvisórioFormaçãoMTC OKValor Faturado €Website URL
Nam119683590103-04-2022xxxx1email address removed for privacy reasonsBraga10/08/2021PresencialEfetivadaComprou01/04/2022Transplante capilar3250 NAONAONAOSIM3250 
Nam223987565103-04-2022xxxx2email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar45009995NAONAONAOSIM4500 
Nam320589840103-04-2022xxxx3email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar42508902NAOSIMNAOSIM0 
Nam422881685503-04-2022xxxx4email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar4500 NAONAONAOSIM4500 
Nam519967775104-04-2022xxxx5email address removed for privacy reasonsBraga04/04/2022PresencialEfetivadaComprou04/04/2022Transplante capilar4500 NAONAONAOSIM0 

Sheet 2

First NamePhone NumberEmailWebsite URLContact IDContact ID Match
Nam1xxxx1email address removed for privacy reasonshttps://www.example.com/11968359010
Nam2xxxx2email address removed for privacy reasonshttps://www.example.com/22398756511
Nam3xxxx3email address removed for privacy reasonshttps://www.example.com/32058984011
Nam4xxxx4email address removed for privacy reasonshttps://www.example.com/42288168550
Nam5xxxx5email address removed for privacy reasonshttps://www.example.com/51996777510
Labels:
1,256 Views
0 Likes
4 Replies
Reply
4 Replies
NikolinoDE

‎Oct 30 2022 06:33 AM

‎Oct 30 2022 06:33 AM

Re: Copy entire row to another sheet if value matche

@sambomim 

first

Turn on the Inquire add-in

then

Compare two versions of a workbook by using Spreadsheet Compare

 

or with VBA, if this is posible in your excel Version.

the code or the file is from a long time ago and I don't even know where it can be from (internet site or from me), but it should work. Code can be found in the file.

 

Hope I was able to help you :).

 

NikolinoDE

I know I don't know anything (Socrates)

 

 

Preview file
37 KB
0 Likes
Reply
best response confirmed by sambomim (Copper Contributor)
OliverScheurich

‎Oct 30 2022 07:02 AM

‎Oct 30 2022 07:02 AM

Solution

Re: Copy entire row to another sheet if value matche

@sambomim 

An alternative could be Power Query.

power query website url.JPG

Preview file
26 KB
0 Likes
Reply
sambomim

‎Oct 31 2022 03:34 AM

‎Oct 31 2022 03:34 AM

Re: Copy entire row to another sheet if value matche

Thanks @NikolinoDE for your help! ;)

0 Likes
Reply
sambomim

‎Oct 31 2022 03:36 AM

‎Oct 31 2022 03:36 AM

Re: Copy entire row to another sheet if value matche

Thanks! This worked for me!!
0 Likes
Reply