Auto Extraction of Data

[Offeror]

Thanks for the help Ravi, I just wanted to ask whether the same code will work for many more sheets or will modification be needed? I have a very basic understanding of vba loops, so plz tell me did you check the entire row for being blank or specific cells? Im attaching a file which more closely resembles the data i work with, just tell me whether the previous macro called "ravi" will work fine or will it require modification.

If yes then look into it. Thanks for your kindness.
Offeror

[Offeror]

Hey, guys help out plz thanks

[Mallycat]

Your post appears to refer to a previous post, but there is no information here to help me to help you. If you could put some more information as to what the problem is, you may get some help

[Offeror]

Ok, there is a workbook containing around 70+ worksheets, each sheet representing a single employee. Each sheet contains a table for a month say january so there are 31 rows for each day. At the end of the day i have to prepare a report of employee names whose sheets remained blank for that particular day. The attachment file in previous post called secondtest contains a sample sheet.

A friend here called Ravi made a macro for me,its called ravi, and it is in this file. This is almost the thing i want with some modifications. I want the resulting report to be created automatically in a particular workbook.

And i want just one specific cell in the row to be the criteria of being blank. because the row contains names of days as well. Check the file and the macro he created and you will get the idea. Thanks

[karan]

There is no macro in the attached file.

Regards,
Karan

[Offeror]

Very sorry for that. Here is the file this time.

[Offeror]

Come on guys, help out thanks.

[karan]

The macro is just fine for your requirement. It will return the names of all those employees whose sheet has no data pertaining to that date (from the C to Z columns). And, it will check all the sheets because it has a For Loop from 1 to the total number of sheets, i.e. this line:

Please Login or Register  to view this content.

Let me know if you need any more help.

Regards,
Karan

[Offeror]

I've tried this files macro for some other dates. I put in some numbers randomly for some other dates and tried to generate report for those dates, but the result was empty. Check out the file. Thanks

[Offeror]

Actually, i've tried this again, and also i've now understood the meaning of the code so now im a better position to modify for my needs. Thanks a lot, ravi, and karan and all those who were kind enough to have a look and provide their expert opinion.

The code is working all right, i will test it with the actual files i work with and then i'll tell you the result. Hopefully it should work fine. Just one thing, the current code does the trick in the summary worksheet, is it possible that it does it in a workbook i specify. I know vba can do it. Just give me the code for getting it to do it in a new workbook.

One more thing, the macro should be such that it will generate report in the same workbook everytime in a way, that the report generated last time remains preserved, and the new report starts where the old one ended.

Thanks.

[Offeror]

Hey there,

Guys help out with this prob. Im stuck with it. Thanks.

[karan]

Code for specifying the Workbook name:

Please Login or Register  to view this content.

[Offeror]

Thanks a lot to Ravi and Karan both of you, and others who were kind enough to have a look at my problem and gave their valued advice. Really cool stuff, thanks a lot.