ANSWERS: 8
  • in the cell where you want the info to change automatically, type '=' then select the cell in the other sheet where the info might/will change.
  • If your list is quite long the VLOOKUP function may be what you need, especially if you don't want to see your entire original list. Give each of the rows in your original list a unique identifying number in the column immediately to the left and make sure that the list is sorted in ascending order of the identifying number. Give the range containing the data you want to be copied a name (select the range and then use the Insert... Name... Define menu). This is just to make the formula easier to type and easier to understand. In the worksheet where you want to see the copied information put the identifying numbers into a column and in the cell immediately to the right of the first one put this formula: =VLOOKUP(A2,Suppliers,1,FALSE) In the formula A2 is the cell in the current worksheet containing the identifying number, Suppliers is the named range, 1 is the first column in the named range and FALSE ensures that only an exact match is returned. Use the Fill Handle to drag the formula across the next three cells and change the 1 to 2 in the second cell, 3 in the third cell and 4 in the fourth. Select all four cells and drag the Fill Handle down as many rows as you need.
  • The best answer, although not a specific response to what you have asked, is to redesign the spreadsheet so that's not a requirement. Multiple times data entry for the same data is a recipe for error. If I were designing a spreadsheet certain to have errors, that's one thing I'd certainly require.
  • You can right click copy the cell; then go to the cell you want linked to the first cell. Select the cell, right click and click on "paste special" then click on the bottom left of the window that states "paste link" That way, anything you change something in the first cell, it changes in the second one. Hope it helps you out. I love this feature.
  • Suppose in Cell A1 of Sheet1 you have name john then give this cell a Name "JohnName". Now in Sheet2 in any cell if you wanna give reference of John just put =JohnName ..... now whenever you'll change sheet1!A1 cell all values of JohnName will be changed ....... You can give name by in the left most box on formula bar where you can see the cell address A1 or B1 etc.....
  • Suppose in Cell A1 of Sheet1 you have name john then give this cell a Name "JohnName". Now in Sheet2 in any cell if you wanna give reference of John just put =JohnName ..... now whenever you'll change sheet1!A1 cell all values of JohnName will be changed ....... You can give name by in the left most box on formula bar where you can see the cell address A1 or B1 etc.....
  • Suppose in Cell A1 of Sheet1 you have name john then give this cell a Name "JohnName". Now in Sheet2 in any cell if you wanna give reference of John just put =JohnName ..... now whenever you'll change sheet1!A1 cell all values of JohnName will be changed ....... You can give name by in the left most box on formula bar where you can see the cell address A1 or B1 etc.....
  • Can I ask a similar question? I have several different versions of my home phone list on my different computers. How can I synchronise? Do I have to combine the versions, then sort and then laboriously check and delete duplications?

Copyright 2017, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy