Auto Extraction of Data

**Offeror** · 02-02-2010, 12:20 PM

Hi,
Im having to work with a workbook containing approx. 70 worksheets, and currently i have to prepare a report by manually looking into all individual sheets. I need an automation so that the report is generated everyday automatically.

Each worksheet is for separate employee, and contains rows for each day in the month, say January, so there are 31 rows. I do daily entry in one row, and the same for all worksheets in a particular day. if in a day a row remains blank, i prepare a report of such employees whose entry was not made.

Can data be extracted in such a way, that a macro evaulated each sheet for the criteria that the row is blank, and if yes it extracts the name of all such employees from all relevant sheets to another workbook?

im attaching a basic file to show the entry, the highlighted row represents the day for which i will prepare the report based on it being blank for an employee. THanks a lot, i need this badly.

**Paul** · 02-02-2010, 01:22 PM

Offeror, please read the forum rules, and in the future do not post your questions in another person's thread (rule #2 - hijacking threads). I've moved your question to a new thread this time, but future posts may be deleted.

Thank you.

**ravishankar** · 02-02-2010, 02:00 PM

Hi
There are 2 macros in the attached file. Choose the one which suits your needs
RAvi

**Offeror** · 02-04-2010, 02:45 PM

Sorry, for posting incorrectly, i'll be careful next time. Anyways Ravi thanks a lot your macro named Ravi was just what i was looking for. Thanks you rock. I want a little further clarification for that i'll make a post of my own. Ok