 |
 | 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 / Worksheet Functions / March 2008Linking worksheet data
I am using Excel 2000. I have a workbook with 100 worksheets. All of the worksheets have the same column and row headers. The data is 100 different pricing situations. I want to make another worksheet that will be able to gather the data from a cell of one of 100 worksheets by specifing ( on the new worksheet) the row, column and worksheet. Can Excel look at three cells to determine the date needed for the fourth? I do not even know if Excel is the program I should use. Please help. You say you want to gather data from "a cell" then you talk about looking at 3 cells to get the data needed for the fourth. Excel can look at many cells to calculate the result for another cell. If the new worksheet is sheet101 and the data you want is on sheet1 in cell A1 then you could put in a cell on sheet101 the formula: =Sheet1!A1. If your sheet name has spaces in it, you must enclose the name in single quotes as in: 'Sheet1'. The best way to enter your formula in A1 on sheet101 is to type an = sign, then select sheet1, then select cell A1 and press enter. Excel will complete the formula for you. If this does not answer your needs, give us an example of what you want. Tyro >I am using Excel 2000. I have a workbook with 100 worksheets. All of the > worksheets have the same column and row headers. The data is 100 different [quoted text clipped - 7 lines] > > Please help. I have Pipe Types in column "A" starting in "A2". I have Pipe Sizes in row "1" starting in "B1". The pricing table starts in "B2". I am trying to automate our quoting system. I was hoping to create "Sheet 101" for the quote sheet or use the bottom of all the 100 sheets I allready have. On the quote sheet we put the Pipe Size in one cell and Pipe Type in the cell to its right we are quoting and then the price in the next cell to the right. Is there a way to put in the Pipe Size in one cell, Pipe Type in another cell, and the Block Sheet Number [1-100] in a third cell and have excell go to that Sheet and grab the price under the Size and beside the Type? > You say you want to gather data from "a cell" then you talk about looking at > 3 cells to get the data needed for the fourth. [quoted text clipped - 21 lines] > > > > Please help. Hi See link below if it's something like that you can use ( Sample Invoice ) http://savefile.com/files/1413506 Regards Cimjet >I have Pipe Types in column "A" starting in "A2". I have Pipe Sizes in row > "1" starting in "B1". The pricing table starts in "B2". I am trying to [quoted text clipped - 42 lines] >> > >> > Please help. Hi Again Forgot to mention to click on Item row and a bottom will appear, by selecting the part it fills the product and price, the Database is on the second sheet Post back Regards Cimjet >I have Pipe Types in column "A" starting in "A2". I have Pipe Sizes in row > "1" starting in "B1". The pricing table starts in "B2". I am trying to [quoted text clipped - 42 lines] >> > >> > Please help. |
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.