Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data merge
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 1234 is a number or code or Name in sheet 1? 3) In Sheet 3 1234 name1 1234 This is in 1 column . Information you require is: from sheet 2 & from sheet 1 & from sheet 2? <IJWTK Quill666 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
data merge
Qull666
Thanks for your response. I was able to use mailmerge of all things to get what I was after! Thanks again! Mike " wrote: 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 1234 is a number or code or Name in sheet 1? 3) In Sheet 3 1234 name1 1234 This is in 1 column . Information you require is: from sheet 2 & from sheet 1 & from sheet 2? <IJWTK Quill666 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Merge the data | Excel Worksheet Functions | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
merge data | Excel Worksheet Functions |