Thread: data merge
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default data merge

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