Closed Thread
Results 1 to 4 of 4

Two spreadsheets linked - moving cells

  1. #1
    Adam
    Guest

    Two spreadsheets linked - moving cells

    Hi All

    I have two spreadsheets which are linked together. Spreadsheet a is linked
    to b so that in spreadsheet b it pulls in the cells B6:B17 from spreadsheet a.

    Unfortunately I need it to pull in b5:b16 so what I'm trying to do is to
    delete a row in spreadsheet a. But when I do that the cell reference in
    spreadsheet b automatically changes. Is there anyway to stop it automatically
    changing?

    Reason I;m not just changing the reference is that there are actually about
    26 spreadsheets that are like spreadsheet a which are linked to b. And this
    would be the quickest way of changing them all.

    I hope this is possible

    Many Thanks

    --
    Adam
    -----------
    Windows 98 + Office Pro 97

  2. #2
    Chris
    Guest

    RE: Two spreadsheets linked - moving cells

    I'm not quite sure I understand everthing you are trying to describe.
    But if you want to fix a cell reference use the $ in front of every
    reference ex
    =SUM($B$5:$B$16). This will then take the info from the referneced cell and
    not adjust if you delete a row.
    I hope this is helpful.
    Chris

    "Adam" wrote:

    > Hi All
    >
    > I have two spreadsheets which are linked together. Spreadsheet a is linked
    > to b so that in spreadsheet b it pulls in the cells B6:B17 from spreadsheet a.
    >
    > Unfortunately I need it to pull in b5:b16 so what I'm trying to do is to
    > delete a row in spreadsheet a. But when I do that the cell reference in
    > spreadsheet b automatically changes. Is there anyway to stop it automatically
    > changing?
    >
    > Reason I;m not just changing the reference is that there are actually about
    > 26 spreadsheets that are like spreadsheet a which are linked to b. And this
    > would be the quickest way of changing them all.
    >
    > I hope this is possible
    >
    > Many Thanks
    >
    > --
    > Adam
    > -----------
    > Windows 98 + Office Pro 97


  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Two spreadsheets linked - moving cells

    That's great, but how do I get the cells to stay linked if I were to move them around? For example, I have information in row B that is linked, I have added new information in row C, and now I have sorted A to Z, which moves them around.

    Quote Originally Posted by Chris View Post
    I'm not quite sure I understand everthing you are trying to describe.
    But if you want to fix a cell reference use the $ in front of every
    reference ex
    =SUM($B$5:$B$16). This will then take the info from the referneced cell and
    not adjust if you delete a row.
    I hope this is helpful.
    Chris

    "Adam" wrote:

    > Hi All
    >
    > I have two spreadsheets which are linked together. Spreadsheet a is linked
    > to b so that in spreadsheet b it pulls in the cells B6:B17 from spreadsheet a.
    >
    > Unfortunately I need it to pull in b5:b16 so what I'm trying to do is to
    > delete a row in spreadsheet a. But when I do that the cell reference in
    > spreadsheet b automatically changes. Is there anyway to stop it automatically
    > changing?
    >
    > Reason I;m not just changing the reference is that there are actually about
    > 26 spreadsheets that are like spreadsheet a which are linked to b. And this
    > would be the quickest way of changing them all.
    >
    > I hope this is possible
    >
    > Many Thanks
    >
    > --
    > Adam
    > -----------
    > Windows 98 + Office Pro 97

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Two spreadsheets linked - moving cells

    AmeriKim,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1