Conditional Merging of 2 Spreadsheets

G

Guest

Hello,
I have been looking on this discussion group for an issue similar to mine,
and I found a few, but not that were exactly what I need. Any help on my
issue would be greatly appreciated!

I have 2 spreadsheets, one with 15 columns and about 20,000 rows, the other
with 4 columns and about 150 rows. 1 Column in each of these spreadsheets (an
email column) have some of the same values. What I want to do is create a
third spreadsheet that has all the common emails from both spreadsheets, and
then merges the data into a single row. Is there any way to do this without
macros? I am very unfamiliar with excel, so please excuse my ignorance on the
matter.

Thanks in advance,
Omeed Musavi
 
G

Guest

Can anybody help with this? It really doesn't seem like anything too
outlandish or difficult...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top