Guru's all.
I hope you can help, I am stuck and in need of some advice and guidance from the Watu....appreciate your time and effort in supporting a luddite...
Aim:
To create a summary sheet of filtered results based on text criteria (open/Closed) from multiple sheets within a workbook.
Example.
Daily sheet is generated containing safety observations (30-40 per day) each carries a status - open or closed.
a workbook is generated for the month (28 days)
Multiple workbooks for the year
I have attached an example with two sheets of raw data, a worked up summary for example results - hope this helps.
ideally I am attempting to summarise all the 'open' items from each daily sheet into a summary sheet for control - an open issues list/task list if you like, expandable as each day is populated within the workbook ( a P2 would be then to do the same for each month) and updating to show 'open' items.
I have tied this with HLOOKUP and VLOOKUP but my skillsets are just too thin at present (I'm still persevering !!) and I think I am on the wrong track, and think this is a macro/VBA task which is way beyond my Ken...
This may be better suited to a database, but excel is the current format for data entry and analysis.
Ideally, the summary has write back functionality - to the original data - not sure if this is possible ??
All suggestions gratefully received - every day is a school day !!
Many Thanks for the help
A.
Bookmarks