 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007copy values from 11 books to 1 sheet
Hi, I am in Book2 in sheet1 cell D4. I need to copy a value from another place. What formula do I need to copy cell K67 from the CLOSED workbook named "Book1" from "sheet2" where sheet2 is protected with a password TO Book2 sheet1 in cell D4. Actually I need to copy 11 different workbooks 4 values from each book from the same sheet. It is MUCH easier to open Book1, even temporarily, and have two windows visible on screen. Then you type = in cell D4 of Book2, click over to the Book1 window, select the Sheet2 tab and then click on the cell you want to copy from (K67) (actually, you are linking to it, but it is effectively the same). Then press <Enter>, and Excel will have taken care of the syntax rules. Close Book1, and you will see the formula in D4 - essentially made up of the full path, filename, sheetname and cell reference. You can repeat this procedure for other files, as required. Hope this helps. Pete > Hi, > I am in Book2 in sheet1 cell D4. I need to copy a value from another place. [quoted text clipped - 6 lines] > Actually I need to copy 11 different workbooks 4 values from each book from > the same sheet. Hi, Thanks . I tried it and worked well. I wasn't shure at the begining wether the book1 MUST be opened or not bt it turned out that it is not necessary. If I copy all the workbooks to another drive and another folder I THINK it will ask me to update the links. Is this true?? (I havn't tried it yet!) Thanks again. Khalil > It is MUCH easier to open Book1, even temporarily, and have two > windows visible on screen. Then you type = in cell D4 of Book2, click [quoted text clipped - 22 lines] >> from >> the same sheet. It will always ask you if you want to update external links whenever you open the file. As for moving the files to another folder, how will Excel know that you have done this? It will look in the path (from your formulae) for the file and if it is not there it will tell you "File not found", so it will not be able to update the links (i.e. the values of the links, not the links themselves). If you are planning to move the files then do that first, before setting up the link formulae. Hope this helps. Pete > Hi, > Thanks . [quoted text clipped - 35 lines] > > - Show quoted text - Thanks for the note Pete. I remember reading something in one of the postings about using VBA code that TELLS Excel to look in the CURRENT PATH. I couldn't find it! Do you know how to do it? Is there a site that tells more about it? > It will always ask you if you want to update external links whenever > you open the file. As for moving the files to another folder, how will [quoted text clipped - 51 lines] >> >> - Show quoted text - I don't recollect that posting, and I don't do enough in VBA to be able to advise you on it. Sorry, Pete > Thanks for the note Pete. > I remember reading something in one of the postings about using VBA code [quoted text clipped - 63 lines] > > - Show quoted text - Thanks Any Way. I will do a posting for it, maybe I can get help about it >I don't recollect that posting, and I don't do enough in VBA to be > able to advise you on it. [quoted text clipped - 78 lines] >> >> - Show quoted text - You're welcome. Pete > Thanks Any Way. > I will do a posting for it, maybe I can get help about it [quoted text clipped - 87 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.