what should i do if i want to link two excel worksheets so that when enter data the other one is updated?
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.
705228
You don't need to install any software for doing this, rather, you just need to write a piece of VBA code to join the tables. If you are not sure how, send me your workbook at your_taurean@yahoo.com and I will help you write that code.\n\nAlso, add an example (by joining a few rows of the two table) to show what the joined result should look like.
696118
Go to Tools>Options. Under save, check compatability options for Excel 2000
967626
EXCELL - Spreadsheets
897335
You can do this in two ways:\nOne: Using Macro.\nTwo: Using functions\n\nI prefer using the option Two as a start.\nNow, I need you to focus with me...\n\n- Enter your two values "Default" and "1000" in two cells (Say Y1:Y2)\n- Create a Combo Box using "Forms Toolbar", that is go to View > Toolbars > Forms\n- The toolbar will show and you can create a combo box from it.\n- Right click on that combo box and go to Properties > Control, select two cells that have your values (Default and '1000') Y1:Y2 as the Input range, select a cell to link this combo box to (Say Z1).\n- Now click ok\n- Where ever you select a value from this combo box, Z1 cell will change to 1 or 2.\n- Your A1:E50 cells need to have this function, need to be changed. I have a question here (Do these cells have a numbers (A) or coming from a formulas (B) ?)\nA) If the A1:E50 cells have all constant numbers, I prefer you choose another range to put this formula in.\nSay G1:K50, put in G1 this formula and copy and paste to the others:\n= CHOOSE( $Z$1, A1, A1/1000)\nB) If they have a formula, just change it to this formula:\n= CHOOSE( $Z$1, [your old formula], [your old formula] /1000)\ndon't forget to change the value [your old formula] to your old formula on each cell.\n\nNeed more help? or would like to see the Macro section?\nmail me here\n\nEnjoy my profile, I am VBAXLMan
818534
may in my humble opinion suggest you do not use works spreadsheet, the spreadsheet module is at best a weak imitation of Microsoft Excel, and Microsoft has shown no interest in updating it since version 4.x which was initially released in 1995- despite new releases having much later version numbers, there have really been no changes or improvements of substance since that time. I would use (if you have not got excel)http://www.openoffice.org
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.
801228
I'm using Excel 2003. This solution should work for any recent version of Excel. \n\n1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".\n\n2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.) \n\nBe sure that the order is Ascending for now, even if you want it to be Descending in your final sort.\n\nIf your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.\n\n3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them. \n\nHope that helps.
832093
If it is not the "Automatic Calculation" issue, then I guess you are talking about links between two files.\nIf so, then you need to change the links values in Edit > Links\nThis happened when you rename / move / delete the president files\n\nVBAXLMan
53850
If you use a reference then the equation result can be updated correctly when the referenced value changes or the equation is moved to a new cell.
94546
You may need to know VBA (Visual BASIC for Applications) in order to do this.  If you want to change the data of one field based on the input into another field, put the code into the field_AfterUpdate() event procedure of the field that will be manually updated.
76070
Actually when you're in Excel you can add a Visual Basic line that makes a SQL query that selects one random name. I don't know the particulars, but I know it's really really easy and it's literally one line of code or two.\nYou could also have two excel files, and one of them acts as a "filter" of sorts, by bringing "external data" from the second one and filtering with the SQL statement.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
907462
It is me who can help you here:\nYou are trying to insert a hyperlink to a [variable] destination. right?\nIf so, I need you to tell me what type of that variable.\nMeans, do you want the hyperlink to change the sheet? or the cells?\nAre all your hyperlinks link to the same file, but differant sheet everyday?\nOr, the hyperlinks are all in the same sheet, but differant cells?\nIn another word, what part of hyperlink is the variable? and what part is constant?\nThe key to solve it here is the function HYPERLINK (Not Insert > Hyperlink).\nYou can go to Insert > function > Lookup and references > Hyperlink\nto insert the HYPERLINK function and enter the link destination as cell content, or as a variable depending on some changes\n\nFeel free to mail me your e-mail address with some details, and I will be glad to solve this one (I like these issues)\n\nEnjoy my profile, I am the VBAXLMan
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
937273
Do the following\nopen your excel file\nCtrl + A\nCtrl + C\n\nopen new word document\nCrtl + V\nnow save your word document
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC