linking cells

  1. G

    Linking a range of cells from one sheet to another and preserving the formatting

    Hi I have linked a range of cells on one worksheet in the same work book to another sheet in the same workbook but I have lost all the formatting. Is there a way to preserve the formatting? I am using Excel 2007 and conditional formatting.
  2. W

    How does one link cells in a single row?

    I have a list of customers, with corresponding data in each row. However, I want to sort the customers by who spends the most money, as well as other characteristics. Is there a way to link cells so that all the information matches up properly when sorting? Thanks, Adam
  3. P

    Linking to other worksheet without $

    I am linking one worksheet to another but when I link the cells the formula comes out as =Sheet1!$A$1 instead of =Sheet1!A1 I have to drag these formulas across and down so is there a setting that will put the formula in in the first place without the $ signs ? (I am using Excel 2010) Peter
  4. X

    Quad-linking cells VBA code

    Hi there, I am working on a piece of code to be able to quad-link cells (any change of any of the cells will be reflected in all the others, no matter where the change was made). To make it easier to use for those in the office who are not that comfortable in VBA, I used a skeleton format I...
  5. B

    Linking Cells Together

    Is ther away to link a cell from one sheet to another and be able to enter data in either cell and it update the other ?! Thanks as always
  6. D

    Linking Rows or columns

    I am not sure weather this is possible or not but i would like to know weather it is possible to link rows so that is you change something in one column it changes it in the other. Any advice is appreciated, deadduck456
  7. B

    Help with BASIC Excel function! Thanks!

    Hi, Thanks for reading. Here is a SAFE link to the screenshot that explains what I'm trying to do. I warn you....it's very basic, I'm just new to excel! I'm basically using a main worksheet with a list of organizations I'm communicating with. This main sheet details the LAST communication...
  8. C

    Linking multiple data from a different workbook - Excel 2010

    I would like to find the subtotal of different range sets (by country and date) from source file and copy it to the target workbook. I use the paste special option, with link, to get the first subtotal and that appears to be fine. However, when I change the range (country or date), the first...
  9. Z

    Inserting lines to link cells

    Hi, This is not easy to explain so I am going to use a visual aid. I have an excel document similar to the pic. I need to insert the green lines to link the applicable cells. How do I do this? Currently I have "x" in each cell I need to link with the green lines. It is not a graph, it is a...
  10. M

    Linking cell info one sheet into another same workbook

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  11. J

    Linking Adjacent Cells

    I have a macro that moves cells in one order to another order. As these cells move is there any way to have the cells right next to each of them move along with them. For example: My macro puts column 1 in numerical order....can I link column 2 to column 1 so that column 2 follows the new...
  12. A

    Networking linked spreadsheets - best practice

    Hi I have a number - about 25 - of manufacturing log spreadsheets that need to exist on a networked workstation - let's call it WKSTN 02. These contain multiple sheets. These logs contain cell references which are linked to several other sheets on a Master Stock List spreadsheet - a separate...
  13. A

    Pivot Table Help

    Hey, I'm trying to create a model that enables me to connect my buyers with properties I have for sale that meet their investment criteria. I'm stuck on a certain part of it and was wondering if anyone would be able to provide me with some insight as to how to go about it. As of now, the...
  14. C

    Paste Link Random N/A

    Hello, I copied a block of cells from one workbook and pasted as a link into another workbook. Most the cells linked perfectly, however, some random cells return #N/A error. When I open the originating the file, it works. The originating file contains no formulas, just values (no special...
  15. W

    inter-sheet linking with shifting cells for auto-updates

    Hi all, I have been trying to figure out how to do something specific which I've come very close to, but not yet achieved. For my data, I am trying to have one sheet link to the prior sheet and the most recent month's data, plus the 5 months before for that for comparative purposes. Thus...
  16. M

    Linking to Unopened Workbook problem

    a Co worker asked me for helpon this one and I'm at a loss on this one. Working with linked files, not using a macro to link but a straight = to the target workbook info, the target file cannot be read if not open at the time. Re-linking brings back the 'cannot find file' message which is...
  17. T

    Date Lookup Within a Workbook

    This seems simple but i'm stumped. I have a change order document with a summary page on the first sheet and subsequent change order sheets. I've linked the sheets so that data entered in the summary sheets appears in the change order sheets and vice versa. On the summary sheet, I want the date...
  18. B

    Linking cells question

    I am linking cells from one workbook to another. The issue I face is the table I am pulling from is part of a dashboard type screen so rows are being added and subtracted above the data I am trying to pull. For instance currently the data I need is B50:I55, but if rows are added it may be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top