+ Reply to Thread
Results 1 to 10 of 10

Is there any way I could transfer data from one sheet to another for specific data content

  1. #1
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Is there any way I could transfer data from one sheet to another for specific data content

    Hi there everyone, Im kinda facing an issue right now at work, and I would really appreciate any help if possible please. Let me briefly explain; I got asked to clean a massive email database in order to reduce our mailing bounce rate. At first all we needed was our customer email addresses but now we also need their location in order to send targeted newsletters to specific regions.

    My question is, now since I have 2 sheets : one with all the customer informations (name addresses postal code city phone number email addresses) [see screenshot n1] and one with ONLY the cleaned emails [see screenshot n2], is there any possible way I could use a formula or a plugin to easily and quickly add the city and postal code to specific cleaned emails from the original excel document ?
    Thank you in advance for the upcoming answers and hopefully I can find some help, cheers everyone.
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,348

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    Hello ALiGW, thank you! Sure, I can do that. There it is, hopefully should be in the attachments. Appreciate the help
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,348

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    Sorry - I'm not clear at all what you want, but let's start with this:

    =UNIQUE(FILTER('original sheet'!F:F,'original sheet'!F:F<>""))

    You may need to replace commas with semi-colons for your French locale:

    =UNIQUE(FILTRE('original sheet'!F:F;'original sheet'!F:F<>""))

  5. #5
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    I'm sorry if I didnt made it clear enough, kinda struggling in English with such advanced topics haha. Basically, I want the new sheet, that right now contains only cleaned email adresses to also feature their correspondant city and postal code. Lets say in the original sheet I had 10 different emails adresses, all linked to a specific person with different informations, after the cleaning only 7 of them still remains because 3 we're not joinable and therefore couldnt receive any email. Well, those 7 only, that are now cleaned, I want to also add their correspondant city and postal code in the new sheet if possible, using the original one. Hopefully that makes things a little bit more precise, I appreciate your help and I will immediatly try what you said

  6. #6
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    Before cleaning the emails data base (original sheet) I had all the customers informations but since after the cleaning only the emails adresses remained (cleaned emails sheet), I want to add their correspondant city and postal code. Therefore sadly I can't copy/paste the city and postal code straight into the cleaned sheets because some emails that originally was there got deleted since they were not joinable. Also the original one used to contains 3690 emails but now the cleaned one has 2674, which also made cells moved so thereforce copy/paste isnt possible.
    Last edited by NorkaryO; 02-14-2022 at 10:50 AM.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,842

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    I believe that the following will do what you want:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Paste into cell B2, drag the fill handle over to cell C2 and then, while B2:C2 are still selected drag the fill handle down as far as needed.
    As AliGW stated you may need to replace commas with semicolons.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  8. #8
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    This worked thank you so much mate!!!

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,842

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

  10. #10
    Registered User
    Join Date
    02-14-2022
    Location
    France
    MS-Off Ver
    365 - 2201
    Posts
    6

    Re: Is there any way I could transfer data from one sheet to another for specific data con

    Did that! Hope you have a blessed day aswell, thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need help with data transfer from one sheet to another in specific cells
    By cuteamit2 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-04-2022, 04:37 AM
  2. [SOLVED] Transfer specific data from one sheet to another with certain logic
    By jimpatel1993 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2021, 09:52 AM
  3. Replies: 3
    Last Post: 10-26-2021, 05:43 PM
  4. How to transfer specific data from one sheet to another?
    By jreloz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2021, 08:57 PM
  5. How to transfer specific data from one sheet to another?
    By jreloz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-22-2021, 12:12 AM
  6. [SOLVED] Transfer specific data onto new sheet
    By Johfra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 11:33 AM
  7. Macros to transfer specific data to another sheet?
    By biggie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2006, 06:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1