SamExcelvba
New Member
- Joined
- Nov 9, 2010
- Messages
- 26
Hi all! I was hoping you guys could help me out with something - pretty basic I think but I can't seem to get my head around it.
I'm basically creating a to-do list. With different categories of jobs on different sheets, but all entered in the same format. I'll use filters to organise these by deadlines, progress etc.
However, what I really want, is a cover sheet that pulls in all the data from the different to-do lists, so that I can see EVERYTHING that has to be done (and again sort by deadline date).
I know I could probably do this all on one sheet with Filter management, but I don't think that will give me the user experience I'm after.
How would I write a macro/VBA to do this? And is there anyway of the update happening real time - or will I have to keep clicking 'run macro'?
Thanks for you help - greatly appreciated as always!
Enjoy the weekend!
I'm basically creating a to-do list. With different categories of jobs on different sheets, but all entered in the same format. I'll use filters to organise these by deadlines, progress etc.
However, what I really want, is a cover sheet that pulls in all the data from the different to-do lists, so that I can see EVERYTHING that has to be done (and again sort by deadline date).
I know I could probably do this all on one sheet with Filter management, but I don't think that will give me the user experience I'm after.
How would I write a macro/VBA to do this? And is there anyway of the update happening real time - or will I have to keep clicking 'run macro'?
Thanks for you help - greatly appreciated as always!
Enjoy the weekend!
