+ Reply to Thread
Results 1 to 1 of 1

Copy ranges of data from Master Sheet to Slave Sheets

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Suitland
    MS-Off Ver
    Excel 2010 - Version: 14.0.6123.5001 (32-bit)
    Posts
    1

    Copy ranges of data from Master Sheet to Slave Sheets

    Hello!

    I've been working on a vacation/sick/personal tracking sheet at work and have completed it recently. Please see the attachment. I tried putting a generic version together but the post would not keep the formatting.

    Everyone in the office is very happy with the formatting (it's clean looking and color coded) except for one detail... printing it is a bit of a chore. I thought I'd try making slave sheets for the individual months. Essentially, I'd have a Master Sheet and then 12 Slave Sheets - one for each month of the year, all formatted to print everything on the sheet to fit to a single landscaped page. I want each month's info to pull from its corresponding place on the Master Sheet with no formatting changes. That way if you wanted to print multiple months, you wouldn't have to "Set Print Area" for each one desired, you'd simply click on the appropriate tabs, hit print, and all changes on the Master Sheet would be present on the Slaves.

    I tried to do this using the "='MASTER SHEET'!A1" but that is not working. It only keeps the top left of the section I highlight and then ignores all formatting.

    Is there a simple way I can do this or is "Set Print Area" my only option without getting too complicated?
    Attached Files Attached Files
    Last edited by mike.haley; 01-23-2013 at 12:53 PM. Reason: Post would not display text as entered.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1