There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus bios bsod computer crash driver drivers error ethernet excel freeze gaming google gpu hard drive hardware hdmi internet laptop malware memory missing monitor motherboard network operating system printer problem ram registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excell merging fields

Reply  
Thread Tools
sexnage's Avatar
Member with 236 posts.
 
Join Date: Jul 2005
04-Nov-2009, 03:35 PM #1
Unhappy Excell merging fields
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

Last edited by etaf; 04-Nov-2009 at 07:48 PM..
etaf's Avatar
Computer Specs
Moderator with 34,394 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
Experience: Intermediate
04-Nov-2009, 04:05 PM #2
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's Avatar
Member with 236 posts.
 
Join Date: Jul 2005
04-Nov-2009, 05:28 PM #3
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's Avatar
Computer Specs
Moderator with 34,394 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
Experience: Intermediate
04-Nov-2009, 06:57 PM #4
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's Avatar
Member with 236 posts.
 
Join Date: Jul 2005
04-Nov-2009, 07:06 PM #5
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's Avatar
Computer Specs
Moderator with 34,394 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
Experience: Intermediate
04-Nov-2009, 07:13 PM #6
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...
__________________
Note: I have very limited time during weekdays to visit here, so there will be a delay in replying
UK timezone
Please let us know what the final solution was to any problem posted
sexnage's Avatar
Member with 236 posts.
 
Join Date: Jul 2005
04-Nov-2009, 07:31 PM #7
Here
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
Attached Files
File Type: xlsx JK test list 2.xlsx (84.4 KB, 624 views)
File Type: docx TEST APP 1.docx (55.6 KB, 26 views)
etaf's Avatar
Computer Specs
Moderator with 34,394 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
Experience: Intermediate
04-Nov-2009, 07:52 PM #8
OK - that should be easier to read now
sexnage's Avatar
Member with 236 posts.
 
Join Date: Jul 2005
04-Nov-2009, 07:54 PM #9
Thank you for your help, I hope I can get this to work.

Thanks
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
05-Nov-2009, 11:09 AM #10
Why not just use the mail merge ability built into Word and use the Excel spreadsheet as your data source?
Attached Files
File Type: doc TEST APP 2.doc (123.5 KB, 35 views)
File Type: xls JK test list 03.xls (184.5 KB, 95 views)
jimr381's Avatar
Computer Specs
Senior Member with 4,183 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
05-Nov-2009, 11:40 AM #11
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?
__________________
"Take what you learn and make a difference with it."
___________________________________________
"Oh, goody!"
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 09:59 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.