Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Hi everyone,
Purpose: create classroom roster between one Excel spreadsheet as data source and another excel sheet. I know how to use one excel spreadsheet as a data source to merge with another word document; however, by using this method, I found that the link between the files keep dropping from time to time, especially when the folder has been moved around. I'm thinking of creating the same layout of the Word document in another Excel spreadsheet and somehow "LINK" the data source and the other spreadsheet together, but I'm not sure how, or whether this is even possible. I'm thinking of using Vlookup or Hlookup, but this function only return one result and I'd like the function to return multiple result based on the look up criteria. Please find my data source layout below: First Name | Last Name | Days | Classroom | DoB ... As you may notice that "Classroom" column will contain repeated information, and if I choose this as the look up criteria in Vlookup or Hlookup, the function only return one result. And that's not the whole roster for that particular classroom. Is there anyone who have done this sort of thing before? Is this possible to do in Excel? I'm using Excel 2003. Thank you, Neon520 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Hi Neon520,
Regarding your original problem, Word links to Excel Workbooks will fail if you relocate or rename the Excel Workbooks - you can move the Word files without problems. Of course, if you move the files to a different PC, the links will fail if any part of the path to the Excel Workbooks differs. If you're going to be moving the files around on a regular basis, you may find it useful to employ the macro code I've posted at: http://lounge.windowssecrets.com/ind...owtopic=670027 -- Cheers macropod [Microsoft MVP - Word] "Neon520" wrote in message ... Hi everyone, Purpose: create classroom roster between one Excel spreadsheet as data source and another excel sheet. I know how to use one excel spreadsheet as a data source to merge with another word document; however, by using this method, I found that the link between the files keep dropping from time to time, especially when the folder has been moved around. I'm thinking of creating the same layout of the Word document in another Excel spreadsheet and somehow "LINK" the data source and the other spreadsheet together, but I'm not sure how, or whether this is even possible. I'm thinking of using Vlookup or Hlookup, but this function only return one result and I'd like the function to return multiple result based on the look up criteria. Please find my data source layout below: First Name | Last Name | Days | Classroom | DoB ... As you may notice that "Classroom" column will contain repeated information, and if I choose this as the look up criteria in Vlookup or Hlookup, the function only return one result. And that's not the whole roster for that particular classroom. Is there anyone who have done this sort of thing before? Is this possible to do in Excel? I'm using Excel 2003. Thank you, Neon520 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Hi Macropod,
Thank you for responding to my post. As much as I'd like to try the method that you suggested, the excel data file and the word merge file are actually in a single folder on desktop and never ever moved before, but the link kept broken for whatever reason. However, the merged files are being access by another user on a separate computer that have access to that same folder. Do you think it has something to do with that? Going back to the solution that I'm trying to do with excel link excel, do you think it's possible? Any resources you could refer me to? Thank you, neon520 "macropod" wrote: Hi Neon520, Regarding your original problem, Word links to Excel Workbooks will fail if you relocate or rename the Excel Workbooks - you can move the Word files without problems. Of course, if you move the files to a different PC, the links will fail if any part of the path to the Excel Workbooks differs. If you're going to be moving the files around on a regular basis, you may find it useful to employ the macro code I've posted at: http://lounge.windowssecrets.com/ind...owtopic=670027 -- Cheers macropod [Microsoft MVP - Word] "Neon520" wrote in message ... Hi everyone, Purpose: create classroom roster between one Excel spreadsheet as data source and another excel sheet. I know how to use one excel spreadsheet as a data source to merge with another word document; however, by using this method, I found that the link between the files keep dropping from time to time, especially when the folder has been moved around. I'm thinking of creating the same layout of the Word document in another Excel spreadsheet and somehow "LINK" the data source and the other spreadsheet together, but I'm not sure how, or whether this is even possible. I'm thinking of using Vlookup or Hlookup, but this function only return one result and I'd like the function to return multiple result based on the look up criteria. Please find my data source layout below: First Name | Last Name | Days | Classroom | DoB ... As you may notice that "Classroom" column will contain repeated information, and if I choose this as the look up criteria in Vlookup or Hlookup, the function only return one result. And that's not the whole roster for that particular classroom. Is there anyone who have done this sort of thing before? Is this possible to do in Excel? I'm using Excel 2003. Thank you, Neon520 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel sheet with links to Word doc | Excel Discussion (Misc queries) | |||
insert an excel sheet into a word doc and keep excel page breaks. | Excel Discussion (Misc queries) | |||
when i insert word art in excel sheet excel file closes automatica | Excel Discussion (Misc queries) | |||
Copy Excel Sheet into word | Excel Discussion (Misc queries) | |||
excel to read a row, if word 'x' in then put on other sheet ?? | New Users to Excel |