Forum Discussion

JoeEason92's avatar
JoeEason92
Copper Contributor
May 20, 2023

Moving database info

I have a database of over 3000 faults from different vehicles. My spreadsheet has column B set up as vehicle number and column C set up as fault location. In column H we input a date when a fault is rectified. With the other columns having fault specifics, parts etc.

 

I want to create a second sheet which can automatically tell if the cells in column H are blank and copy the rows those cells are in to a separate spreadsheet in order to keep a separate record of "live" faults and use this to more easily display the info visually. I already have filters set up on the original sheet, but needing the other 3000 "closed" faults on this sheet complicates the conditional formatting formulas on my visual display, so hoped it would be easier to copy the information into the separate sheet this way.

  • JoeEason92 

    On the second sheet, copy the header row (or rows) from the database sheet.

    In column A, below the header(s), enter the formula

     

    =FILTER('Data Sheet'!A2:H4000, 'Data Sheet'!H2:H4000="")

     

    Replace Data Sheet with the real name of your database sheet.

Resources