+ Reply to Thread
Results 1 to 1 of 1

determine if cell is empty and return date

Hybrid View

Acidman629 determine if cell is empty... 01-17-2013, 01:40 PM
  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    determine if cell is empty and return date

    I have a workbook with multiple worksheets. Sheet 1 contains columns with dates (a schedule of activities) which are changed frequently by a column which adds days to the dates and each column with dates has a column to mark an item complete. When an item in the schedule is marked complete it returns a date of completion. So to recap.

    Column A - list activities in a schedule
    Column B - a list of dates which change
    Column C - a number that indicates how many days to change the day by (1 to add a day or -1 to take a day away etc.)
    Column D - a column to mark items on the list complete
    Column E - a column with dates that appear when items on the list are marked complete.

    On Sheet 2 I want to track the original date (because the dates will change) and the final date. Tracking the final date should be easy it's the original date causing me a dilema. How can I write a macro that will record the original date from sheet 1 onto sheet 2 but not update to the new date(s) if they are changed? I can't think of a formula that I can use for this so I'm guessing that it will have to be a macro.

    I have attached and example

    Thank-you in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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