Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Sheet Linking
Name: Chris Date: December 3, 2003 at 10:57:57 Pacific OS: Win2K CPU/Ram: P4 - 450
Comment:
How can i have one sheet in an excel file link to another excel file's sheet so that when the 2nd file's sheet is updated, file 1 is updated as well?
Name: Jennifer SUMN Date: December 3, 2003 at 11:08:29 Pacific
Reply:
Simple. Say for example you want to link a cell on Sheet 1 to cell D14 on Sheet 2. Here's the code:
=Sheet2!D14
That's it...
0
Response Number 2
Name: Chris Date: December 3, 2003 at 11:14:10 Pacific
Reply:
OK,
But if I want to have the entire Sheet from one excel file to be duplicated on another excel file sheet, how do i do this?
0
Response Number 3
Name: johnleong Date: December 3, 2003 at 19:32:34 Pacific
Reply:
Follow steps:
1. select the sheet you wanna duplicate 2. right click and choose "move or copy..." 3. select "(new book)" from "To book:" drop down menu 4. check the option of "create a copy"
Summary: Hi, Can anyone help me out with unlocking excel sheet. I have a sheet which is protected by password. I dont remember any letters. I found utilities on net but they all provide utilities to give on...
Summary: I have a server that is home to an Excel spreadsheet that has hundreds of links within it. All the links are in a single folder on the same server. I need to move all this data to another server, bu...
Summary: hi y'all, how can i make a drop down list in a excell sheet. Like we do in the internet when filling out forms...eg. date of birth, where all the years appears, and one can choose from. I intend to ad...
0 
