data merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys!! I have a merge question for you! I have 150 names that I need to
have entered into a record. Here is an idea of what I have:

This is in the first sheet
Column1
name1
name2
name3
name4

Here is what is in the second sheet, everything is in the first column but
each entery is in a different row/line.
1234 Usernameneedstogohere 1234
1234 usernameneedstogohere 1234
data
data
data
moredata
data
data
moredata

How can I get excel to create this merge?
1234 name1 1234
1234 name1 1234
data
data
data
moredata
data
data
moredata
1234 name2 1234
1234 name2 1234
data
data
data
moredata
data
data
moredata
1234 name3 1234
1234 name3 1234
data
data
data
moredata
data
data
moredata
1234 name4 1234
1234 name4 1234
data
data
data
moredata
data
data
moredata

Can excel do this for me? Any help would be apreciated!!
Thanks!

Mike
 
Dear Mike,

It is possible by using Reference formulas such as VLookup and IndexMatch,
provided that it is organised systematically and consistency.

Maybe you would like to provided a detailed aspect of what you are trying to
do.


My Question:

1) In Sheet 1 is 1 column worth of names?
Jane Doe
John Doe
McDowell

Yes / No?

Is there a code or some reference number attached to the name?
Example:
----A------------B
1234------------Jane Doe
1235------------John Doe
1236------------McDowell

Yes or no?

2) In Sheet 2
1234 Usernameneedstogohere 1234
Click to expand...

1234 is a number or code or Name in sheet 1?


3) In Sheet 3
1234 name1 1234
Click to expand...

This is in 1 column . Information you require is:

from sheet 2 & from sheet 1 & from sheet 2?

<IJWTK>
Quill666
 
Qull666

Thanks for your response. I was able to use mailmerge of all things to get
what I was after! Thanks again!

Mike
 
Back
Top