[sexnage]

Hi, I have a problem with my excel. I use microsoft office 2007. I need to know how to merge 2 files into one.

<EDIT by ETAF
Take certain cells from Excel and merge them into a Word document, examples of word and excel are in a later post, and highlighted the cells that needed to be move from Excel and where inserted into Word >


Example, I have a Tae Kwon Do Studio, and my students are all doing test. I have the test form that I setup in excel, and in another file I have the name of all the students. How can I insert in the test file the name of the students that are testing??? Do I have to type the name one by one? I am sure there is a way to merge a field to fill the blank on the test paper right? if any one knows how please let me know. It will be very helpful.

Thank you

Jaime

[etaf]

whats the common info between the two sheets , i'm thinking of using somethign like vlookup

do you have a sample of each you could upload without sensitive info in we could see and try out

[sexnage]

Yes I dont mind, the files are 2 different files under the same directory.

The main file is the test application where on page one I need to fill the name, ID#, DOB, Class, Present and Desired fields. The pages 2-4 only need to automatically plug the name on each page.

The file that is coming to merge is the one that has all the personal info about the student. I hope this helps.

Please let me know if you can come out with any ideas. Thank you Very much.

Jaime

P/S how do I upload this files to you????

[etaf]

OK - lets be clear on what you are trying to do , I thought it was 2 excel sheets

But you want to take data out of a word document and merge into an excel sheet

I think a very clear brief of what you want to do....

[sexnage]

I am so sorry here is the scenarion. I need to merge the file from Excel into the Word file.

Sorry for the confusion


Thank you

Jaime

[etaf]

OK I have no idea how to do that - someone with more knowledge will answer - can you describe which columns of info - you need moved into which part of the word tables

Perhaps highlight the cells in different colours on excel and the same colours in word - to show the move...

[sexnage]

Ok, here are both file. Everything that is in Blue on the Excel file needs to merge with what is in blue in the Word file.

Thank you very much for your help

Jaime

[etaf]

OK - that should be easier to read now

[sexnage]

Thank you for your help, I hope I can get this to work.

Thanks

[slurpee55]

Why not just use the mail merge ability built into Word and use the Excel spreadsheet as your data source?

[jimr381]

It sounds like you need to setup an Access database with reports for the testing. You can print out said reports, annotate notes and then add the data back into the database. Let me know if you intersted in doing this instead. This will be a one place solution and alleviate the need to switch between applications. Do you have MS Office 2007 Professional?