Data Entry With a Filter

CherylAK

OK - I have a sheet that tracks our invoices by VENDOR.  We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children).

The sheet is long so I create a filter to pull up a specific vendor.  In the first blank row under that vendor I type in the information and then I save it.  I take off the filter and the row is GONE.   If I filter again and select the same vendor...the row that disappeared is still there.  Filter off..gone!

When I type the information in without using the filter...I just scroll all the way down until I find the vendor I want and then type in the information and save it.  It stays there.

So how can this be?  I hope someone can help me figure this one out!  Thank you.

Andrée Starå

Hi Cheryl,

It's because the row you are typing in the information on probably isn't the next row. If you check on the left side, you can see which row it is, and you should be able to find it.

A possible workaround could be to add a few "empty" rows that match the filter so you can fill them in in the right position directly. 

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

CherylAK

Thank you Andree!  You are awesome!

Andrée Starå

Wow, Thanks!

I'm always happy to help!

Best,

Andrée