+ Reply to Thread
Results 1 to 2 of 2

Automatically Change formatting of Cell in Another Sheet

  1. #1
    Registered User
    Join Date
    06-29-2008
    Location
    Perth, Australia
    MS-Off Ver
    MS Office 2003
    Posts
    84

    Automatically Change formatting of Cell in Another Sheet

    I have an Excel workbook with three sheets, Draft, Data and Report.

    To give you an example, if I manually change the format of Range E55:E83 in the 'Draft' sheet, to 1 decimal number, I would like the format of Range N39:N51 in sheet 'Report' to change automatically to number with 1 decimal..... and so on.

    Is there any way I can do it by formula, or do I need to use VBA?

    Can someone give a detailed answer please.

    Many Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Automatically Change formatting of Cell in Another Sheet

    I think it has to be done in VBA macros.

    The coding is easy for this(all done with the macro recorder).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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