Macro to list out all the things from all the worksheets in a workbook based on followup date

[imhappiee]

Friends!!!

I am very new to excel macros,and im giving a try with the following challenge so please try to help me out.

I have an excelbook which consists of several worksheets say 10, all named with the customes. and all are similar kind of worksheets, which consists of ,S.no,machinery, Activity,Description,Supply Party, Contacted ,Remarks, Status, Followup Date (dd/mm/yy), and few other relevant things.

now as i usually update and change the follow up dates along with the remarks , I want to run the macros in such a way that it lists out all the things irrelevant of customers in a new excel sheet which comes under the date that i specify along with all the things related to it..


PLEASE HELP ME OUT BUDDIES, IT WILL BE A GREAT HELP FOR ME AND PLEASE DO ASK IF YOU HAVE ANY CONFUSION IN MY POST.

 

[Tom Urtis]

I want to run the macros in such a way that it lists out all the things irrelevant of customers in a new excel sheet which comes under the date that i specify along with all the things related to it.

If you never saw your workbook, would you know what the above quote means? I bet not.

What does "things irrelevant of customers" mean?

How do you specify a date?

What does "all the things related to it" mean? All things related to a date? All things related to a customer? All things related to some other list?

Try explaining your workbook again in a way that someone who never saw it, which is everyone reading this except you, could comprehend what you are talking about, what you want to happen, why you want it to happen, and what your expected results are.