Raw data and dashboard

[Noah101]

I have a question,

If I have a raw data set on sheet 1 and on sheet 2 I have a dashboard that has formuals and structures the data, but I will be addiing more and more account information to my raw data, but only want the dashboard to pick up my active accounts data from the raw data what would I do to the dashboard or my raw data?

Mabey somehow create macro button that removes all the non active closed accounts from the raw data set ? Any suggestions?

Thanks

 

[FDibbins]

You give us almost nothing to go on.

What does your data look like?
What formulas are you using?
what is your expected outcome?

 

[Noah101]

Ok how about this I just want to log stuff but once that's logged and complete I want the row to disappear how I do this?

 

[FDibbins]

Still would need answers to the questions I asked