Forum Discussion
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 Paciente | Customer ID / Nº Processo | Data criação Paciente | Contacto Paciente | Email Paciente | Clinica | Data Consulta | Tipo Consulta | Estado da Consulta | Estado Proposta | Data Venda Proposta | Tipo Proposta | Valor Proposta € | id_referenciador_pt | Paciente KO | Provisório | Formação | MTC OK | Valor Faturado € | Website URL |
| Nam1 | 196835901 | 03-04-2022 | xxxx1 | mailto:email address removed for privacy reasons | Braga | 10/08/2021 | Presencial | Efetivada | Comprou | 01/04/2022 | Transplante capilar | 3250 | NAO | NAO | NAO | SIM | 3250 | ||
| Nam2 | 239875651 | 03-04-2022 | xxxx2 | mailto:email address removed for privacy reasons | Braga | 02/04/2022 | Presencial | Efetivada | Comprou | 02/04/2022 | Transplante capilar | 4500 | 9995 | NAO | NAO | NAO | SIM | 4500 | |
| Nam3 | 205898401 | 03-04-2022 | xxxx3 | mailto:email address removed for privacy reasons | Braga | 02/04/2022 | Presencial | Efetivada | Comprou | 02/04/2022 | Transplante capilar | 4250 | 8902 | NAO | SIM | NAO | SIM | 0 | |
| Nam4 | 228816855 | 03-04-2022 | xxxx4 | mailto:email address removed for privacy reasons | Braga | 02/04/2022 | Presencial | Efetivada | Comprou | 02/04/2022 | Transplante capilar | 4500 | NAO | NAO | NAO | SIM | 4500 | ||
| Nam5 | 199677751 | 04-04-2022 | xxxx5 | mailto:email address removed for privacy reasons | Braga | 04/04/2022 | Presencial | Efetivada | Comprou | 04/04/2022 | Transplante capilar | 4500 | NAO | NAO | NAO | SIM | 0 |
Sheet 2
| First Name | Phone Number | Website URL | Contact ID | Contact ID Match | |
| Nam1 | xxxx1 | mailto:email address removed for privacy reasons | https://www.example.com/1 | 196835901 | 0 |
| Nam2 | xxxx2 | mailto:email address removed for privacy reasons | https://www.example.com/1 | 239875651 | 1 |
| Nam3 | xxxx3 | mailto:email address removed for privacy reasons | https://www.example.com/1 | 205898401 | 1 |
| Nam4 | xxxx4 | mailto:email address removed for privacy reasons | https://www.example.com/1 | 228816855 | 0 |
| Nam5 | xxxx5 | mailto:email address removed for privacy reasons | https://www.example.com/1 | 199677751 | 0 |
4 Replies
- Thanks! This worked for me!!
first
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 :).
I know I don't know anything (Socrates)
Thanks NikolinoDE for your help! 😉
