Obtain information from Excel?
 

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.

Obtain information from Excel?
 

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" wrote in message
...
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.