+ Reply to Thread
Results 1 to 4 of 4

if today's date in b2 then enter content of a1 in another spreadsheet

  1. #1
    Registered User
    Join Date
    06-01-2008
    Posts
    2

    if today's date in b2 then enter content of a1 in another spreadsheet

    I am doing a renovation of 800 apartments and have an Excel spreadsheet set up so that each unit # is listed column A. Then all of the items that have to be done in each apartment are listed in row 1. What I'd like to have is another spreadsheet that lists the unit numbers of those that have a particular date in one of the cells.

    This other spreadsheet is what the contractors see, so that it shows the units to be worked in tomorrow, for example.

    Is there a way to do this?
    Last edited by VBA Noob; 06-01-2008 at 12:01 PM.

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    In lets say sheet 2 A1 enter: =IF(Sheet1!A1=TODAY(),Sheet1!B1,"")
    The formula says that if the value in sheet1 A1 is equal to today then show the value of sheet1 B1 if not show a blank.

    Does that help?
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    06-01-2008
    Posts
    2
    What does the () represent? Also, there will be previous dates and info in the same cell...so can I just put the * symbol before TODAY?

    =IF(Sheet1!A1=*TODAY(),Sheet1!B1,"")

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    When you asked for Todays date it is shown in a cell in Excel like this =Today() so i incorporated it in a formula for you.

    Previous dates and info in the same cell? thats a recipie for trouble, anyway you need to upload your workbook so we can see what you are trying to achieve as your explanation is a little sketchy!

+ 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