Select Range from column values

M

Maarkr

I have a long list of names and associated info in rows with embedded dept
names and would like to break this out by dept... either as a page break or
named range, so I can print out each dept separately. Looks kindof like this:
A B C
Finance Dept
bob... ssn ID
sally... ssn ID
fred... ssn ID
10 more names...
Marketing Dept
Joe...
Lou...
3 more names...
Contracts Dept
Jenny...
Alice...
Next Dept...
thx
 
D

Duane Hookom

This looks like you are using Excel. If so, either ask your question in an
Excel news group or move your data to Access and ask a question in the Access
Reports news group (or even here if you like).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not split... break apart? 5
Breakout groups from one column of data 2
imported field list w groups in field 7
Open a form from a continuous form based on two field values 2
Create List of Unique Values from several columns 2
How to check for duplicate values within a column 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Count unique values among duplicates in a subtotal range 2

Top