+ Reply to Thread
Results 1 to 2 of 2

Copying Formulas Between Worksheets While Keeping Reference to Original Worksheet

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2013
    Posts
    2

    Copying Formulas Between Worksheets While Keeping Reference to Original Worksheet

    I have a series of formulas in Row 1 across the columns in worksheet A. I would like to copy these formulas to a single column and down rows in worksheet B while retaining the references to worksheet A. I know that I can manually enter the references in worksheet B but that would take a long time to do. Any help with this would be much appreciated.
    Last edited by PandaBear2014; 03-04-2014 at 06:32 PM.

  2. #2
    Registered User
    Join Date
    03-04-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Copying Formulas Between Worksheets While Keeping Reference to Original Worksheet

    I just manually entered references, pasted across columns, then copied and pasted using transpose...

+ 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. [SOLVED] Copy formulas from one spreadsheet to another keeping the original sheet cell reference
    By Sheepdog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2012, 02:41 PM
  2. Copying formulas but incrementing the worksheet reference
    By Chris Mizon in forum Excel General
    Replies: 2
    Last Post: 03-08-2012, 09:26 AM
  3. Replies: 3
    Last Post: 11-15-2011, 09:15 AM
  4. [SOLVED] Setting original Formulas for copying
    By Jim May in forum Excel General
    Replies: 0
    Last Post: 07-26-2006, 03:50 AM
  5. Copying data but keeping original
    By mellowe in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 10:25 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