I want to drag data from one Excel spreadsheet into another but don't know how!?
404712
You can do this by VLOOKUP\n\nSheet 1 contains the full list \nSheet 2 your item codes\n\nIn Sheet 2.\nB2=VLOOKUP(A2,Sheet1!A1:C3,2)\n\nThis looks up the value in A2 in the range A1:C3, and returns the second column (B).
1172805
I would use Data Validation and VLOOKUP in Excel to do this.\n\nType in the 2 lists (for convenience lets start in A1) then add a third column:\nSerial#1          Combo#1          =A1\nSerial#2          Combo#2          =A2\nSerial#3          Combo#3          =A3\n\nMake the lists as long as you need. We created the third column for later; it just copies the serial numbers over to simplify things for the VLOOKUP formula.\n\nNow that the data is input we will need to create a drop-down menu. Since the data is in columns A-C, click in E1 to select the cell and click Data | Validation… In the Allow box choose List and type the range for the combinations in the Source: field (in our example: A1:A3). Now, click on F1 and type this formula:\n=VLOOKUP(E1,A1:B3,2,FALSE)\nIn the parentheses you will have this data: \n-E1 is the criteria you will look up in the array.\n-A1:B3 is the array where the data resides (remember this is from the example, yours will be longer).\n-2 in our formula tells VLOOKUP to pull the data in the 2nd column that matches our criteria from the 1st column.\n-False tells VLOOKUP to look for an exact match.\n\nWe have now created the Serial Number lookup that returns the proper Combination. To lookup the Serial Number from the Combination, we just do the steps again.\n\nClick in E2, choose Data | Validation… Again, in the Allow field choose List, but this time we need the combinations in the drop-down (B1:B3); click OK. The formula for F2 is almost the same:\n=VLOOKUP(E2,B1:C3,2,FALSE)\nThe only differences is that the criteria and array are shifted; the criteria down one row and the array over one column.\n\nIf you wish to hide the rows that contain the array, just right-click on the column headings and choose hide.
831403
I guess you don't have Excel.\nGet OpenOffice.\nwww.openoffice.org
1086777
This is not a simple question to easily be answered.  First, the 'data' must be established in Excel.  Obtain the different fields of information and place each into it's own column.  Sep-10, Chicago, GreenBay.  Place the data beginning down a ways like row 15, and column D.  Label each column with a heading and keep the label simple: Begin with a letter, no more than 8 characters, no blanks, no spaces, meaningful to content, and not a reserved word (Excel command like SUM).  Then highlight the entire data range you placed and choose the INSERT-NAME-DEFINE and type database.  Then you can Go to the Heading line and highlight that line and copy to row 2 immediately above and paste it and also below the bottom line and leave 10-15 empty lines and paste the heading line again.  The top area should be INSERT-NAME-DEFINE and type Criteria.  The bottom area should be INSERT-NAME-DEFINE and type Extract.  When you define the Criteria you should include one blank line immediately below that heading line where you can place criteria that you would like to extract to the extract area from your 'Database".  The Extract area is just the data on the copied header line.  You place information like "Giants" under the FIRSTTEAM column and then on the Excel menu you select DATA-FILTER-ADVANCE FILTER-COPY TO ANOTHER LOCATION - UNIQUE RECORDS ONLY - OK and all the 'Giants' information will be copied to the extract area.  You can UNDO a selection by DATA-FILTER-SHOW ALL.  \n\nThis is the Database feature within Excel and is simple to setup and very useful to extract many types of data.
96164
I suggest you use a DTS package, making a DTS (Data Transfermation Package), a function of the SQL Server, will\ngreatly simplify the task of getting data from Excel to SQL server. they can be saved and setup to run on a schedule or just used once. Great feature :)
55468
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.
105195
I assume both Worksheets are in the same file...\n\nIf so, you simply do the following:\nIn the second worksheet in the cell you want to display something from the first worksheet, type:\n\n=SheetName!CellName\n\ni.e. if your info is on a Worksheet called Sheet1 and the cell is B1\n\n=Sheet1!B1
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
1053655
Look above to the left. Click on File/Import And Export
61805
try using this site. its a tutorial. http://www.usd.edu/trio/tut/excel/
411443
this is the best Excel site I've ever found on the web. Lots and lots of tutorials from beginner level to expert. \n\nhttp://www.MrExcel.com\n\ngood luck
952409
That is a good question needs a GOOD answer.\nYou have some tools in Excel to do this.\nTry:\n1- View > Toolbars > Forms\nand draw the object you want (Use Checkbox and OptionBox will help you alot)\nRight click on each of these boxes and go to Properties > Control where you can select the way this control controls the action.\nYou can alos use ListBox or ComboBoxes.\n2- You may need some VBA macros to complete the job\n\nI can do alot of these for you, need you to send me more info here in Y! Answers and I can promise I will help\n\nEnjoy my profile, I am the VBAXLMan
221896
There's an easy way to do this. I've given you some very basic code.\n\nCopy and past this code into your VBA code under the same sheet as your data. (Press ALT-F11 to get to the VB editor and double click the sheet name of the tab you are working on).\n\nSub SortText()\n    LookRow = 2\n    PutRow = 2\n    txtCounter = 1\n    Do\n        txtColor = Cells(LookRow, 1)\n        If txtColor = "" Then Exit Do\n        txtSize = Cells(LookRow, 2)\n        txtRange = Cells(LookRow, 3)\n        Cells(PutRow, 5) = "Trial #" & txtCounter\n        Cells(PutRow + 1, 5) = "Color " & txtColor\n        Cells(PutRow + 2, 5) = "Size " & txtSize\n        Cells(PutRow + 3, 5) = "Range " & txtRange\n        PutRow = PutRow + 5\n        LookRow = LookRow + 1\n    Loop\nEnd Sub\n\n\nWhen you run the macro it will take the data and arrange it into the columns you wish. Be aware that it will paste the data into column E of the same page and will overwrite anything you have there, so backup your data first.\n\nYou can also assign this to a shortcut-key with Tools>Macro>Macros... You will need your security set to Medium for this to work.\n\nIf you wish the data to be saved on a seperate page, please email me at wabbitt1970 @ hotmail.com
131728
There are several ways to go about this, depending on how you have already entered data and what exactly you want it to look like.\n\nDid you already enter data into Excel?  Is it in the format: 9'3", 9'4", etc.?\n\nIs this data entered along a row (across) or a column (vertical), or some other layout?\n\nDo you want Excel to show the data in that same format (i.e. 9'3") or do you want it to say something like 9.25 ft?\n\nAny oher specific information I should know about what you're trying to do?  This way I can give you a useful answer.
569995
Are you trying to get rid of the blanks?\n\nOne way is just to sort the column--that will pull all the blanks to the top or bottom, where they are easy to delete.\n\nIf you need to keep the order that values are in, try this:\n\n1. Select the entire column.\n2. On the edit menu, choose "Go to..." then click "Special..."\n3. In the box that comes up, choose "Blanks" and hit OK.\n\nYou should now be back in the sheet, with all the blank cells selected.  Right click, choose "Delete...", then choose "Shift cells up" and hit OK.\n\nThis is for excel 2002, it might be a little different in other versions.
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
186438
Check http://www-class.unl.edu/psycrs/handcomp/hc1t.PDF\n\n\nAlso, Follow this procedure:\nEnter the values of X into the designated cells, beginning in the top-most cell. After each entry, depressing the 'tab' key will take you down to the next cell in the column. After completion and verification of data entry, click the button labeled «Calculate». If you wish to perform another analysis with a different set of data: click the «Reset» button if the value of N for the new set of data is undefined or smaller; click the «Reload» button if the value of N is larger than undefined.\n\nImporting data from a spreadsheet. Within the spreadsheet application, select and copy the column of data. Then return to this page, click the cursor into the data-entry field and perform the 'Paste' operation. It is important to make sure that the final line in the data-entry field entry is not followed by a carriage return. (An extra carriage return at the end of the list will be interpreted as an extra data entry whose value is zero. Importing data via the copy and paste procedure will almost always produce an extra carriage return at the end of a column.) After the bivariate list has been pasted into the data-entry field, click the cursor immediately to the right of the final entry in the list, then press the down-arrow key. If an extra line is present, the cursor will move downward. Extra lines can be removed by pressing the down arrow key until the cursor no longer moves, and then pressing the 'Backspace' key (on a Mac platform, 'delete') until the cursor stands immediately to the right of the final entry.\n(see http://faculty.vassar.edu/lowry/t_single.html)