+ Reply to Thread
Results 1 to 2 of 2

Linked Worksheets

  1. #1
    Karen
    Guest

    Linked Worksheets

    I am trying to link worksheets, data from Quickbooks that I export from
    Quickbooks into an excel spreadsheet and one that i have created.I have
    figured out how to link them but te problem is every month I have to import
    the information and instead of overwriting it creates a new page. I need it
    to overwrite the infomation every month and am not sure how to make that
    happen. Any help would be appreciated. Thanks
    --
    Karen

  2. #2
    Dave Peterson
    Guest

    Re: Linked Worksheets

    Maybe you could just create a new worksheet "Current". Then copy the current
    months data into that worksheet. Then all the formulas would still point to
    Current, but the data will have been updated.

    Karen wrote:
    >
    > I am trying to link worksheets, data from Quickbooks that I export from
    > Quickbooks into an excel spreadsheet and one that i have created.I have
    > figured out how to link them but te problem is every month I have to import
    > the information and instead of overwriting it creates a new page. I need it
    > to overwrite the infomation every month and am not sure how to make that
    > happen. Any help would be appreciated. Thanks
    > --
    > Karen


    --

    Dave Peterson

+ 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