Results 1 to 10 of 10

transposing data not copying to the target cell(s)

Threaded View

  1. 07-22-2015, 07:58 AM #1
    jdin54
    jdin54 is offline
    Registered User
    Join Date
    05-07-2014
    Location
    Perth, Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    transposing data not copying to the target cell(s)

    Hi,
    I am transposing data from one worksheet to another in the same workbook.
    When I transpose the data from the originating workbook to the target cells in the other workbook (using copy, paste transpose) I either get no data copied across or a circular reference warning.
    Could someone please show me a way by vbasic how I can do this.
    Please see file. I am copying the Outgoings totals from worksheet tab 07JULI&E H40:X40 to tab 07JULRECON G6:G22 and the Income totals from 07JULI&E H10:X10 to tab 07JULRECON D6:D22
    Thanks in advance
    Jdin54
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copying multiple unique values into one spreadsheet (Transposing the data)
    By Ardiko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 03:02 AM
  2. How to display a blank when copying a date from another workbook if the target cell is bla
    By DanielWinning in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2013, 08:10 AM
  3. copying data from excel files in a source folder to target folder
    By Javed07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 04:27 PM
  4. system time stamp a cell when change in target cell. ( note target cell is formula ref)
    By R_VBA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  5. Transposing columns of data into one cell
    By virtualluffy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-04-2012, 02:43 PM
  6. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 PM
  7. copying data from source workbook to target workbook by headers
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2009, 11:35 PM
  8. Turn off Excel's automatically copying number formatting of target cell
    By ind in forum Excel General
    Replies: 4
    Last Post: 06-13-2007, 12:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1