+ Reply to Thread
Results 1 to 2 of 2

Excel should allow calendar based spreadsheet linking.

  1. #1
    kacivic
    Guest

    Excel should allow calendar based spreadsheet linking.

    I use several workbooks at a time that are set up monthly that have an
    individual spreadsheet for each day. I do fairly complicated data linking in
    that I have to change each equation that I copy to the next spreadsheet to
    make it link to the appropriate day's sheet in another work book. It would
    be helpful if Excel could recognize the pattern in the links on the different
    spreadsheets and automatically modify the links for me in the same way you
    can drag-copy an equation within a spreadsheet.

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...heet.functions

  2. #2
    PC
    Guest

    Re: Excel should allow calendar based spreadsheet linking.

    Alternatively one could use the existing XL functions that enable a user to
    accomplish this task, which include among others:

    OFFSET
    MATCH
    INDEX
    COUNT & COUNTA
    SUMPRODUCT
    SUMIF

    And of course there PIVOT TABLES

    PC

    "kacivic" <kacivic@discussions.microsoft.com> wrote in message
    news:6840C064-6A12-49F6-8501-F52628A01600@microsoft.com...
    > I use several workbooks at a time that are set up monthly that have an
    > individual spreadsheet for each day. I do fairly complicated data linking

    in
    > that I have to change each equation that I copy to the next spreadsheet to
    > make it link to the appropriate day's sheet in another work book. It

    would
    > be helpful if Excel could recognize the pattern in the links on the

    different
    > spreadsheets and automatically modify the links for me in the same way you
    > can drag-copy an equation within a spreadsheet.
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow

    this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    >

    http://www.microsoft.com/office/comm...heet.functions



+ Reply to 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