Hi, I have a huge excel file that lists transactions by peoples names. How
can I easily print each individual on seperate sheets so that non of the
individuals overlap onto others sheets?

Thanks

Do each individual appear on their own row? if so how many columns do
they take up?

Dave;439411 Wrote:
Hi, I have a huge excel file that lists transactions by peoples names.
How
can I easily print each individual on seperate sheets so that non of
the
individuals overlap onto others sheets?

Thanks


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121908

You can use the below macro. which will put page breaks after each name...I
tried this with the names below in Col A.

Sub InsertPageBreak()
Dim lngRow As Long
For lngRow = 3 To Cells(Rows.Count, "A").End(xlUp).Row
If Range("A" & lngRow) < Range("A" & lngRow - 1) Then
ActiveWindow.ActiveSheet.HPageBreaks.Add Befo=Range("A" & lngRow)
End If
Next
End Sub

ColA
Name1
Name1
Name1
Name1
Name1
Name2
Name2
Name2
Name2
Name3
Name3
Name3
Name3
Name3
Name3
Name4
Name4
Name4
Name4

If you are new to macros; set the Security level to low/medium in
(Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below code. Save. Get back to
Workbook. Run macro from Tools|Macro|Run <selected macro()

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi, I have a huge excel file that lists transactions by peoples names. How
can I easily print each individual on seperate sheets so that non of the
individuals overlap onto others sheets?

Thanks

Yes, They appear on there own row. Collectively they take up about 6000 rows.

Thanks

"Simon Lloyd" wrote:


Do each individual appear on their own row? if so how many columns do
they take up?

Dave;439411 Wrote:
Hi, I have a huge excel file that lists transactions by peoples names.
How
can I easily print each individual on seperate sheets so that non of
the
individuals overlap onto others sheets?

Thanks


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121908

hi dave,

kindly look possibility of using filters to the file. i strongly feel that
using filter can solve your problem.

select all the data u r having - click on data - filter - autofilter

click on the small downward arrow appearing on the top row and select the
name of the individual u want to take print, and try to take the print.

if it helps, kindly click on yes below

"Dave" wrote:

Hi, I have a huge excel file that lists transactions by peoples names. How
can I easily print each individual on seperate sheets so that non of the
individuals overlap onto others sheets?

Thanks

use data/subtotals there is a checkbox option to put a page break between
groups, very easy

"Dave" wrote:

Hi, I have a huge excel file that lists transactions by peoples names. How
can I easily print each individual on seperate sheets so that non of the
individuals overlap onto others sheets?

Thanks