+ Reply to Thread
Results 1 to 3 of 3

Coping text using Formulas -

  1. #1
    Steven
    Guest

    Coping text using Formulas -

    I am trying to format text on a worksheet, where any text in cell A1 entered
    on Sheet 1 automatically fills in a cell on Sheet 2. My formula on Sheet 2
    reads:

    =Sheet1!A1

    The text copies fine, but I need the properties and formatting to go with
    it, such as text color, bold, row height, etc. Can someone help?

  2. #2
    Registered User
    Join Date
    08-18-2005
    Posts
    59

    RE: Copying text using Formulas

    The easy way to do what you're describing is to select the entire worksheet 1, copy, select the entire worksheet 2, and paste special --> formats.

    You could also write some VBA code to do the same, if you were so inclined, but this i think should do it.
    Excel_Geek
    http://blog.excelgeek.com/

    "...I'll do that in Excel for $50..."

  3. #3
    Steven
    Guest

    Re: Coping text using Formulas -

    I should probably explain. Worksheet 1 is Detailed information. Worksheets
    2 thru 10 are summaries of 1, where only critical cells are being copied
    over. Hence why I was using the formula to automatically copy over the data
    from Sheet 1 to Sheet 2.

    Unfortunately, I'm not proficient enough with VBA to do anything. Any other
    suggestions?

+ 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