Solved

Excel Page Break on downloaded file based on location

Posted on 2013-06-13
5
303 Views
Last Modified: 2013-06-14
I have a downloaded report that I open in excel.  It is a list of all the appointments for every physician office here in the hospital.  I want to provide a page break based on the change of location.  So if cardiac unit is CAR03 and gastro office is GI1 then I would want a page break between these two offices so when I print this report it will separate the offices.
0
Comment
Question by:kvrogers
  • 3
  • 2
5 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39244671
Hi,

Could you send a dummy example?

Regards
0
 

Author Comment

by:kvrogers
ID: 39244833
Here is a copy of the report.  I just came from a meeting on this and here is what they want.  

This is a report that will be updating constantly.  They would like spreadsheet "Admits" and spreadsheet "Consults" combined and then separated by Physician name.  This should also include some type of Page Break by Physician name so that it can be printed and separated by physician for easy handout.  

Please note that originally column B include patient name.  This column has been removed.
Copy-of-rounds-for-kate.xlsx
0
 

Author Comment

by:kvrogers
ID: 39244891
The combined sheet should be sorted by physician name but print by physician separately for easy handout.  I don't think I made that clear before.

Thanks,
K
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39247049
Hi,

In the file attached
The macro associated with the button reads the file you choose, combines the Admits sheet data with the Consults sheet data, sort it by MD and then insert the page break per MD

Regards
CombineLists.xlsm
0
 

Author Closing Comment

by:kvrogers
ID: 39247191
This is just what I was looking for.  Thanks again.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now