Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a formula thet reads (If A2=A1,"",INSERT PAGE BREAK) ?
Excel spreadsheetwith many columns. Column A has customer names, other
columns have product, price, pak, etc. Sorted data by column A. I want to print seperate pages for each customer. So I want to insert a page break above each new customer. So if A1 and A2 differ, I wish to insert page break above A2. Normally, I would go to cell A2 and alt-I,B. But I have hundreds of lines with dozens of unique customers. So I'm looking to insert a new column A (customers will then move to column B, of course), and formulate in A2: (@if A2=A1,"",INSERT PAGE BREAK) . Then copy it to the entire column! Does anyone how to do this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Detect page break settings | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I delete the page watermark in the page break preview? | Excel Discussion (Misc queries) | |||
How do I change "PAGE 1" characteristics in page break? | Excel Discussion (Misc queries) |