#1
|
|||
|
|||
Find email
Hello,
I have 2 different excel files. The first file students.xls, has many names, surnames and the emails of my students. In D column I use the CONCATENATE to join the two columns to one. I have a second file info.xls in excel that I store some notes about some of the students about their attendance. Most of the sheets are named by a student's name (not all of them). What I want is a macro, that takes the name of a sheet in the second file lets say that a sheet is called James Peter, opens the first file that has all the names and emails, finds that name, and copies only his email in the a1 cell of the second file automatically. Can anyone help me? students.xls : Name Surname EMAIL Full name Peter James test1@test.com James Peter (=CONCATENATE(B2;" ";A2)) John Papas test2@test.com Papas John Nick Jones test3@test.com Jones Nick |
Tags |
find, macro |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot find file to attach in email | megabyte | Outlook | 0 | 09-23-2020 05:35 AM |
How to find FB email address anyone | yoyo4 | Windows | 0 | 11-20-2017 09:56 AM |
Can't find how to assign categories to email in outlook 2016 | Bino | Outlook | 3 | 11-05-2015 11:35 AM |
Outlook 2007 'can't find server' when sending email | martinlest | Outlook | 2 | 04-28-2014 09:27 PM |
How to find complete path to email from search window? | Jennifer Murphy | Outlook | 1 | 08-12-2011 03:36 PM |