Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a large worksheet contains rwos with name and address columns. it is
sorted in ascending order by the last name column and address. I want to print a list of the names and addresses with page breaks at specific letters. How can I locate the first row with a last name beginning with a specific letter so that I can insert a page break? I know I can do this manually by scrolling throught the list, finding the right row, selecting it and inserting a page break. However, I would like to create a macro to insert all the page breaks automatically. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I find a mode while disregarding a specific cell value? | Excel Worksheet Functions |