Can you help me update my Excel spreadsheet?
829436
Just add an extra column which extracts only the month and the day from the date column. Let's suppose that the column containing dates is column A, staring with row 2. In the extra column, on the second row, the formula will be:\n=TEXT(A2, "mmdd"). Copy the formula downwards, for all the rows.All you have to do then is to sort by that extra column
520836
Use the vlookup function. \n\nLet's suppose your loan numbers in both sheets are in column A. In the newer spreadsheet, enter =VLOOKUP(A1,OtherSheet!A:A,1,FALSE)\n\nWherever the vlookup returns an #N/A error value means that there is no matching value from the second sheet in the first sheet.\n\nTo check the rest of the fields in the records, you will have to drag the formula across and change the column number (i.e. the 1 in the example above)\n\nAlternative\n\nYou could also merge both spreadsheets into a temporary worksheet. When you create the first sheet, add a column at the far right with a label 'Version'. Put 'Old' for each old record. Then paaste the new data underneath it, put 'New' in the extra column.\n\nCreate a pivot table. Put the version column in the row area, then put the loan number under the row area. Put any additional items under loan number. You need one data field, you can put loan number there again, but double click once in the data area and set it to count.\n\nYou can now play around with the pivot table to compare any fields you like.
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
459913
Excel has that limitation.\n\nLook into using MS Access instead.
516121
How about this:\n\nhttp://support.microsoft.com/?scid=kb;en-us;285337&spid=2512&sid=1292\nhttp://office.microsoft.com/en-us/assistance/HP051985111033.aspx\nhttp://asp2.wlv.ac.uk/its/website/selfhelp/help/excel/MainDifferencesExcel2000andExcel2003.asp
33456
lotus is an older program. excel is best. but annoying when it comes to formulas.
816802
I have been through this several times here on Y! answers.\nI have the software you need.\n\nSend me your e-mail address to send it to you\n\nEnjoy my profile, I am VBAXLMan
523331
You might consider linking an instruction to refresh the pivot table to the Excel event that is triggered when a user jumps from tab to tab. But this would only work if they could be expected to move around in the workbook and not remain on one tab.\n\nFor example, I inserted this code in each excel sheet object. When a user moves to a different tab, I have instructed Excel to refresh a particular PivotTable (which in my system is called "PivotTable2", and happens to be on "Sheet1".\n\nPrivate Sub Worksheet_Activate()\nSheets("Sheet1"). PivotTables("PivotTable2"). PivotCache. Refresh\nEnd Sub\n\n(The sheets refresh command is all part of one line - this yahoo screen may break it on to two lines!)\n\nIf you wanted to use this kind of trigger, then you would need to insert this coding on EACH worksheet object (not the modules of course). If you have many PivotTables that need to be refreshed, then you can write one macro to refresh them, and then call the refresh macro from the worksheet objects. (The refresh macro would be stored in a module.)
18740
There is an application that integrates with Excel called Crystal Xcelsius.  Its really cool.  I'm not sure if this is quite what you are looking for, but the graphs that come out of it are excellent and they are adjustable.  They have a couple of examples on their website.\n\nhttp://www.xcelsius.com/Products/XL_products.html
235596
go to wwww.windowsupdate.com and when asked click on download an Active X control, this should allow you to use the site and download your updates
962079
Copy the data from the original one, go to the other one and paste.  A little clipboard icon will show up on the bottom right of the cell, click on it.  A menu will pop up and just click on 'link cell'.  When ever you update the info on the original is should reflect on the other one.
462317
http://update.microsoft.com/
878692
Try the following sites:\nhttp://www.homeandlearn.co.uk/ME/mes8p1.html\nhttp://www.mpsge.org/xltable/index.html\nhttp://www.spc.int/statsen/english/publications/spess14/Download_Excel_Tables_E.htm
543882
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
461796
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
835185
My understanding is that someone sent you a file that is in excell 2007 - if this is correct then - if you are able to open the file, then go to "save as" and under the file name there is a menu where you can save the file to an earlier version of the software or even into a different format (like txt and so on).\n\nGood Luck!