My manager at work wants to do something in Excel and has asked me as I am one of the more computer literate people in the office for help. I have no idea if it is possible to do what she wants and I need a little advice as my instinct says it is not but I may be totally wrong here ( I think what she wants can only be done in Access)
She needs to be able to access all the cases we work on and bring up relevant ones based on some options.
Her idea is to have an Excel spreadsheet with information on the work we do in them and on another worksheet have some filtering options which will then select and display only the cases which match what she is looking for.
Can this be done in Excel or is the realm of Access?
I have attached an excel doc to show what her idea is but I am not convinced Excel is the answer as she thinks and if anyone has any thoughts I would love to hear them.
Thanks
Max
search engine.xls
Excel can do this, but it will require VBA programming to do it simply based on that design. A macro could essentially open that other file in the background, filter it for the dates and location entered, then copy all the visible data into the RESULTS, then close the background workbook.
Having said that, Access may be a much better solution for sharing data in realtime over a lot of users.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks