How do I refer to a cell in another excel document ? I need to collect some data from another spreadsheet into the sheet I am working on.
208726
pomme#3 has suggested a good way...another way is copy the cell then paste it on another excel doc...right click that cell (where u have pasted) and click on option link cells...this will modify the changes u will do in the doc from which u have copied
170139
I got this from http://www.extension.iastate.edu/Pages/Excel/excel.html\n\nMicrosoft Excel is a member of the spreadsheet family of software. Spreadsheet software is used to store information in columns and rows which can then be organized and/or processed. Spreadsheets are designed to work well with numbers but often include text. Sometimes text in a spreadsheet is called a label, because it is labeling columns and rows of numbers. Numbers are called values sometimes, and can include numbers for counts or measurements, dates, times, and calculations from numbers. Spreadsheets can help organize information, like alphabetizing a list of names or other text or reordering records according to a numeric field. However, spreadsheets are more often used for calculating, such as totaling a column of numbers or generating a more sophisticated formula to calculate some statistical measure on a list of numbers. \nSpreadsheets and databases are in competition and have similar features. Yet the way they work in the background is different. When you work in a spreadsheet, you view the data you are entering as a section. In a database, you only see the data you are entering--you have to request a report or different display to see more of the information. Other differences are: (1) databases are more often used for applications with long textual entries, (2) very large applications (thousands of entries) are more often handled in databases; and (3) spreadsheets are easier to learn to use and get calculations from than a database program. This latter reason is why many researchers and students prefer spreadsheets for keeping track of their data over databases.\n\nIt is impossible to give a complete listing of applications that can be done in spreadsheets, but they include budgeting displays, checkbook registers, enrollment records, inventories, coded surveys, field and laboratory research data, and financial and accounting applications.\n\nThe capacities of Excel are as follows. You can have 256 columns of information. You can have up to 16,384 rows. That comes out to over 4,194,000,000 cells of information and that's only on the first sheet!!! You can have 16 sheets of information in one workbook, and the number of sheets can be increased, if needed. Excel refers to each file as a workbook, because there can be multiple sheets (pages) in one file.
95378
I've uploaded a simple spreadsheet to the link below.  Anything else and you should probably find someone in the office who knows Excel.
87660
this method you can cc to the sheet(s) you select on the same cell of each worksheet.\nhold ctrl and click all sheet tabs at lower left corner that you want to mirror the data, click the input sheet first, go to the cell and make entry, say A1, when done, doubleclick the other sheet tabs, will get you back to single sheet entry.
89708
I think you're trying to do this:\n\n1) Open a new Excel file\n\n2) Click Insert > Object \n\n3) Select the Create from file tab\n\n4) Click browse and browse to the Word doc.\n\nAlternatively, a copy and edit>paste special would probably  also do what you're wanting.\n\n>\n\nAre all 13 pages the same labels?  If so, then just copy everything on the first page of the Excel worksheet (CTRL-C) and paste it normally into 12 more pages with CTRL-V.\n\nIf not, then unfortunately you're probably going to have to copy each page of the Word doc and paste special into Excel.  \n\nAlso, when you paste into Excel, you might look at the paste options by clicking on the paste options button that comes up right next to the cell that you pasted the information.  There is a wizard in there that might make the labels look better than otherwise.
137806
If you are using an absolute reference to f4, then all you have to do is match back up the correct mileage you want to multiply the mileage rate by. If they are listed vertically, with f9 being the first cell, you can just click and drag down, the forumla should look at f10, f11, f12, ect while still maintaining the same rate in f4. \n\nIf not, you are going to have to edit the formula after you copy to reference the correct mileage.
194365
In MS Excel, go to the cell where you want your answer displayed.\n\nPress =\n\nYou then enter your formula, clicking different cells on different sheets as required.  eg go to sheet1 and select a cell with the mouse.  You'll see sheet1!A4\n\nthen key the rest of your formula.  example:\n\nsheet1!A4+sheet2!B7+sheet3!G1\n\nIf your sheets are named differently, replace sheet1 wit the name of your sheet.
662508
Is there is no SUB command similar to SUM, my suggestion would be to make a second column, the same size as the one you are trying to subtract.  You can put it off screen, or so, then no one can see it.\n\nFor this example, we will assume you have the column A with the values you want to subtract.  We will also assume that column B is the new second column.  Both columns data starts at 1, ie, A1, and B1.\n\nNow, the cell B1 should have the formula '=A1' to have the same start value.\nThe cell B2 and onwards should have the formula: '=-A2', '=-A3', etc.  This is 'equals minus An'.\n\nThe get the total, have the formula as '=SUM(B1 : Bend)'\n\n[Edit]\nWhere Bend is the last row in column B, eg, B4.\n[/Edit]
371427
A fantastic place to look for excel answers is Google groups.\n\nFor programming you can follow this link:\n\nhttp://groups.google.com/group/microsoft.public.excel.programming\n\n\nYou can ask any question and within minutes to a couple hours your question will be answered.  If you have other questions on Excel just search for google groups excel and get tons of answers there on anything you EVER wanted to know about excel.  I had a problem I could not solve and asked my question. It was pretty complicated and withing 15 minutes I had my answer!!! I love that place for excel questions and answers!\n\nI guarantee you will be happy with the results
73090
1. =average(a3:d3); more specifically, the average of whatever is in cells a3 through d3.\n\n2. cell\n\n3. Orientation (can't see all the options, but that's not one)\n\n4. Adding arrow and text\n\n5. Empty cells are not included in counts\n\n6. Right-click on the cell containing a formula; choose Format Cells ...; in the Number tab, change the type to Text.\n\n7. An equals sign, the name of the worksheet we are referencing, an exclamation point, the cell reference by column and row, using dollar signs: =another!$B$4
254103
File.. Get External Data.. Link Tables .. browse to the xls file    would set up a permanent link to the excel data and give the spreadsheet a kind of table name. Then it can be queried. You want to use several columns over time and you can use an 'Append query' to append data to a table; but experiment with a crosstab query. In that way, your Access table would always have 2 fields plus maybe a ColumnNumber field where you could have a default value of 1 the first week, 2 the next week, etc.. A crosstab query would present that data as several several columns (one for each ColumnNumber value). When your Access skills increase, you might be very glad that you used a small number of fields because it makes the querying of the data simpler to maintain, in my opinion.\nAs for VLOOKUP, you can research "query table joins" and see how a query in design view lets you choose the field which 2 tables have in common. One table is really the excel spreadsheet presented as if it is a table; the other table is the real access table.
232162
Assuming cell A1 has the number you want to save as the following code will work:\n\nSub SaveAsName()\n    savename = Range("A1").Value\n    ActiveWorkbook.SaveAs Filename:= _\n        "C:&#92;Documents and Settings&#92;Owner.BLACK&#92;My Documents&#92;" & savename & ".xls"\n        \nEnd Sub\n\nYou will have to change the part of the path within the double quotes to match your SaveAs path
291293
Make one on a spreadsheet
21573
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.
601092
The easiest way to do this, that would not require very much programming knowledge at all would be to use the 'Publish as Webpage' feature in excel.\n\nYou can set it so that every time the spreadsheet is updated and saved, it also saves a file, readable by internet explorer, into a folder of your choice. This way you can reference the file in the rest of your site or in a frame or whatever.
99380
I don't have a real answer for you.\n\nBut you can either use formulas in each cell, or apply Visual Basic Macros. I have done a lot of VBA, but only with Word. VBA is pretty easy - except you need to know the names of the various objects. But sample macros are floating around and Microsoft is fairly good about having details on this sort of thing.\n\nIn fact, now that I think of it, you might be better off writing the whole thing in Visual Basic and skip Excel. (Which, of course, does you no good if you don't have VB.)
376864
Tab is a key build-in Excel file to jump from one cell to the next one.\nThat is why you couldn't do it easily.\nDo you have to use 'Tab'?\nIf yes, then you need to make a macro in each sheet with this name\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\n\nThis will run whenever a cell is selected, (including 'Tab')\nso you need also to check if the 'Tab' is pressed using ASCII code.\n\n\nmail me if you need more info\n\nEnjoy my profile, I am the VBAXLMan