Need easier way to extract department data from raw data

[tsunami1977]

I currently download from a database the raw data for 25 departments.
Unfortunately the database is very limited and will dump the 25 departments in one worksheet but does have a line to divide the departments (not all lines are the same and sometimes the department numbers are missing).

Now I do copy each department's data from the raw and paste it into its own worksheet. I do this for all 25 departments and then format them.

Pivot table will not work because each department's label is not consistent.

What I currently do is too time consuming. I am hoping there is an easier way to extract individual department data more easily.

Anyone has suggestions?

Thank you!

 

[PA HS Teacher]

will dump the 25 departments in one worksheet but does have a line to divide the departments (not all lines are the same and sometimes the department numbers are missing).

So what can we use to discern where one department ends, and another begins. Is the line between the departments the same, and what type of line are you talking about. Could you post an example of the transition from one department to another?

 

[Smitty]

Can you post an example?

Find the link to Colo's HTML Maker at the bottom of the page. It will allow you to do that.

Smitty

 

[tsunami1977]

Sorry, I can't get the HTML Maker installed. I need to read the FAQ to figure it out. Below is a rough copy of how the department divider looks. It's actually not a divider more of a page break, so departments with a lot of data have more than one of these lines. In this, you can see Department 605 being shown.


al Expenses 433 0 (433) 433 0 (433) 468,567 0 (468,567)
============== ============== ============== ============== ============== ============== ============== ============== ==============

By US Training Dept/Training/ 605
Current Month Current Month Variance Current Quarte Current Quarte Current Quarte YTD YTD Variance
Actual Budget $ Actual Budget Variance Actual Budget $
2004 - 12 2004 -12 2004-4 2004-4 2004-4
============== ============== ============== ============== ============== ============== ============== ============== ==============
Expenses:

ayroll Expenses
Salaries 10,160 25,555 15,395 35,773 79,099 43,326 139,191 316,396 177,205

 

[tsunami1977]

Here is the COLO screen shot.

Mr.Excel.xls
	B	C	D	E	F	G	H	I	J	K
171	alExpenses	433	0	(433)	433	0	(433)	468,567	0	(468,567)
172		==============	==============	==============	==============	==============	==============	==============	==============	==============
173
174							ByUSTraining	Dept/Training/	605
175		CurrentMonth	CurrentMonth	Variance	CurrentQuarte	CurrentQuarte	CurrentQuarte	YTD	YTD	Variance
176		Actual	Budget	$	Actual	Budget	Variance	Actual	Budget	$
177		2004-12	2004-12		2004-4	2004-4	2004-4
178		==============	==============	==============	==============	==============	==============	==============	==============	==============
179	Expenses:
180
181	ayrollExpenses
Training Dept. 1.25