+ Reply to Thread
Results 1 to 4 of 4

How to copy formatting/text/formulas from one worksheet to another.

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    Vancouver
    MS-Off Ver
    Excel 2003
    Posts
    27

    How to copy formatting/text/formulas from one worksheet to another.

    I am not sure if this is the right forum for this topic. I am new to excel; however, I understand the concepts.

    I am trying to copy everything from one worksheet to multiple worksheets. I also need to be able to edit this "master" copy and have it automatically update every other worksheet. If I was to change the colour, text, boarder or even font of a cell in the "master" worksheet it would need to automatically change on every other worksheet.

    Is this possible?

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: How to copy formatting/text/formulas from one worksheet to another.

    I think you'd need VBA code to do that. Let me know if you want to proceed.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    03-16-2014
    Location
    Vancouver
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: How to copy formatting/text/formulas from one worksheet to another.

    How difficult is this? Is it something I could understand based on a step-by-step process? Perhaps a code I could copy/paste?

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: How to copy formatting/text/formulas from one worksheet to another.

    Let's define some parameters first. Approximately how big is the main spreadsheet? How often will it be updated? Will you be doing a lot of updates (font size, color, back color, borders, etc.) or just an occasional change here and there?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-08-2013, 06:38 PM
  2. Replies: 1
    Last Post: 04-27-2012, 10:42 AM
  3. button to copy worksheet with formulas referencing previous worksheet
    By Alexelius in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-28-2011, 09:40 AM
  4. Add a row, copy formulas, and formatting
    By sp135 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2010, 10:32 AM
  5. Formatting of formulas in single worksheet
    By netgame27 in forum Excel General
    Replies: 1
    Last Post: 01-14-2010, 11:20 AM

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