Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to know if it's possible to have a macro (or something automated) to
insert a page break at every change of data in my column A of data. (I've got about 15,000 rows of data and will probably end up with 9,000 page breaks.) I'd like to end up with something like this: A B C SORT ACCT SHARES Apple, Anne 12345 50,000 Apple, Anne 20987 7,000 --------- page break --------------- Banana, Mike 25678 14,000 Banana, Mike 59873 600 --------- page break -------------- Banana, Karen 25679 34,000 I'm ultimately trying to get the data for each SORT person to print on a letter template. Can ya help me out?! :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
data before page break lost during import | Excel Discussion (Misc queries) | |||
Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) |