Forum Discussion
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 ...
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.
Perfect, that looks like just what I need