Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Programming > Other Programming   »   working with Excel Links

Answer this Question Ask about Other Programming
 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Apr 24, 2008, 09:26 AM
BLM001
New Member
BLM001 is offline 		 
Join Date: Apr 2008
Posts: 1
BLM001 See this member's comment history on his/her Profile page.
working with Excel Links
I have a master spreadsheet (it is a price list) with multiple rows of information, organized by columns. I need to link the information in each row to different excel work sheets.

Reply With Quote
 
     

Answers
 
 
Old Apr 24, 2008, 09:38 AM   #2  
retsoksirhc
Senior Member
retsoksirhc is offline
 
retsoksirhc's Avatar
 
Join Date: Mar 2004
Location: Michigan
Posts: 741
retsoksirhc See this member's comment history on his/her Profile page.
Send a message via AIM to retsoksirhc
That's not too hard to do once someone actually shows you, but it's awfully hard to guess on your own.

To reference a cell on another sheet, you use 'Name of sheet'!CellNumber

If the sheet anme is one word, you don't need the quotes.

=SUM(Sheet1!A1:G1) for example, could be a formula on Sheet 2, and it would pull the values automatically.
  Reply With Quote
 
     
 
 
Old Apr 24, 2008, 09:53 AM   #3  
ScottGem
Computer Expert
ScottGem is online now
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 22,926
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
You need to define what you want to accomplish by linking. Its not hard to link a cell in one sheet to a cell in another workbook and/or sheet. But depending on what you want to accomplish it may be more involved.
  Reply With Quote
 
     
Answer this Question Ask about Other Programming

« Previous Question | Next Question »

Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
EXCEL - Wrap Text not working! MelbGal75 Spreadsheets 6 Aug 11, 2008 01:52 PM
Outlook Links not Working ggatiss Email 6 Aug 24, 2007 04:40 AM
Internet Explorer Links not working bascottil Internet & the Web 0 Dec 5, 2006 06:24 PM
Internet Explore Links Not Working farisl Internet & the Web 1 Dec 27, 2004 04:50 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 05:55 PM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.