Thanks for the input. I am looking for a way to have the summary sheet update after entering the data without employees needing excel knowledge. I there a way to make the filters "Sticky"?
Mike
I have a mini dashboard I am making to make it easier to check that our inventory is in balance.
I have a worksheet with 4 columns:
Financial Code
General Ledger Balance
Inventory Asset Balance
Difference
How can I make a list of unique Financial codes where the Difference column...
Hello Everyone,
My name is Mike and I am a small business owner in Eugene, Oregon USA. I have always loved Excel and our EMS system has given me many reasons to use it. Generally I am running text reports, using Monarch to extract the data then pasting that into my dashboards.
I noticed that...