Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I merge data in 2 sheets matching rows of data by last name? Corb Excel Discussion (Misc queries) 1 March 18th 07 05:32 PM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM
Merge the data gandhi318 Excel Worksheet Functions 0 December 30th 05 02:28 AM
how do i get my mail merge to update the data source at each merge Steel_Monkey Excel Discussion (Misc queries) 0 November 30th 05 08:41 AM
merge data mhei Excel Worksheet Functions 3 April 11th 05 10:45 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"