Results 1 to 1 of 1

Changing dates on linked sheets

Threaded View

  1. #1
    Registered User
    Join Date
    12-26-2010
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2011
    Posts
    42

    Changing dates on linked sheets

    I have a challenging task to complete and need some help. In essence we have an entry sheet which relates to a specific date and returns a result for a number of hours required. This result then needs to update a second sheet which includes that date. I am able to reference the dates but as soon as I change the date on the entry sheet, the data on the second sheet changes. Is there a simple way of retaining the data from preceding entry sheets without using copy and paste special to make it an integer rather than a formula?

    I have attached the sheet.

    Thanks

    Uncle H
    Attached Files Attached Files
    Last edited by Uncle heFTy; 05-05-2011 at 01:12 AM. Reason: Title too general

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