Results 1 to 2 of 2

Thread: Not to Include Data that Moved to a New Spreadsheet

  1. #1

    Red face Not to Include Data that Moved to a New Spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am hoping this is a quick and easy fix. I've tried to research and I get answers explaining how to pull data, which I already know. Please see the formula lines below, the second line is returning data that was moved to a new spreadsheet. I only want Active Data from the RCCSM Employees spreadsheet.

    =IF(ISBLANK('RCCSM Employees'!AK5),"TBD",'RCCSM Employees'!AK5)
    =IF(ISBLANK('Retired-Term'!AL19),"TBD",'Retired-Term'!AL19)
    =IF(ISBLANK('RCCSM Employees'!AK6),"TBD",'RCCSM Employees'!AK6)

    Thanks

  2. #2
    How would I use the formula above but ensure it only pulls date from the RCCSM Employees spreadsheet. So that if a complete row is moved into the Retired-Term spreadsheet it would not show up in the spreadsheet that comes from the main spreadsheet. I hope I am not being too confusing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •