Obtain information from Excel?

[CharElaine99]

I have 48 pages (65,536 lines each) of data and need to extract details (ie,
all hours totalling 41 hours per week pasted to a new worksheet and the same
for 42 hours worked per week, 43 hours, etc.) Is there a macro or something
I can use to do this? I've already summed all the hours and have them posted
in each cell (example ... 8-9-9-8-10-6 (50) ). Can anyone help me with this
hugh task?

Thank you.

[NickHK]

Is the structure of the worksheets suitable for SQL or a Pivot table ?
e.g. SELECT Count(TotalHours) From WS WHERE TotalHours=41

NickHK

"CharElaine99" <[email protected]> wrote in message
news:[email protected]...
> I have 48 pages (65,536 lines each) of data and need to extract details
(ie,
> all hours totalling 41 hours per week pasted to a new worksheet and the
same
> for 42 hours worked per week, 43 hours, etc.) Is there a macro or
something
> I can use to do this? I've already summed all the hours and have them
posted
> in each cell (example ... 8-9-9-8-10-6 (50) ). Can anyone help me with
this
> hugh task?
>
> Thank you.