Matching cells and copying row between sheets

[juliat2]

Hello,

I need help with data on different sheets. On the main business unit sheet named for it's VP, Murphy, I have a list of employees in column A. On the shared mailbox sheet, I have a list of shared mailboxes (SMB) owned by different employees with the name of the owner (employee) also in column A. I would like to match column A from the SMB to the employee in column A in Murphy and copy the row from SMB to under the row in Murphy. I want to leave the row in SMB.

There are no duplicates in column A in Murphy, but there will be duplicates in SMB because some employees own more than one shared mailbox.

I hope this makes sense and any help will be greatly appreciated.

Thanks!
Julia

 

[James006]

Re: Need help with matching cells and copying row between sheets

Hello,

If Sheet1 is Murphy and Sheet2 is Shared Mailbox, the initial step in Sheet1 is to have the following formula :

=MATCH(A2,'Shared Mail Box'!A:A,0)

Should the shared Mailbox be located in column B ... to bring it back you would use :

=INDEX('Shared Mail Box'!B:B,MATCH(A2,'Shared Mail Box'!A:A,0))

HTH

 

[juliat2]

Re: Need help with matching cells and copying row between sheets

Hello,

If Sheet1 is Murphy and Sheet2 is Shared Mailbox, the initial step in Sheet1 is to have the following formula :

=MATCH(A2,'Shared Mail Box'!A:A,0)

Should the shared Mailbox be located in column B ... to bring it back you would use :

=INDEX('Shared Mail Box'!B:B,MATCH(A2,'Shared Mail Box'!A:A,0))

HTH

Thank you so much for helping, but what I need is to copy the whole row from SMB sheet to under the row where the employee is named on Murphy. So this is what it should look like:

Murphy Sheet:
Smith, John SmithJ13 ITWorker Plano Tx

SMB Sheet:
Smith, John Webmaster Mailbox WEB12 Plano Tx

Final look on Murphy:
Smith, John SmithJ13 ITWorker Plano Tx
Smith, John Webmaster Mailbox WEB12 Plano Tx


I just need to put the shared mailbox information into the Murphy sheet under it's owner. Hope this makes sense!
Julia

 

[James006]

Re: Need help with matching cells and copying row between sheets

Hello,

What is not very clear ... is the following : which cells are containing what data ...?

Cheers

 

[juliat2]

Re: Need help with matching cells and copying row between sheets

I was able to work this out with the formula you posted. I just added a blank line after every employee and was able to paste the formula into the blank row and then delete the blank rows that were left. A little extra work, but not as much as copy and pasting 1000 shared mailboxes into the Murphy sheet. Thank you so much for your help!

Julia

 

[James006]

Re: Need help with matching cells and copying row between sheets

Glad you could fix your problem ...:wink:

Cheers