Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Excel Page Break on downloaded file based on location

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
kvrogers
Asked:
kvrogers
  • 3
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

Could you send a dummy example?

Regards
0
 
kvrogersAuthor Commented:
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
 
kvrogersAuthor Commented:
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
 
Rgonzo1971Commented:
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
 
kvrogersAuthor Commented:
This is just what I was looking for.  Thanks again.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now