+ Reply to Thread
Results 1 to 1 of 1

Need macro to export data and transpose it to a data table

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Need macro to export data and transpose it to a data table

    I am having trouble recording this so it functions repeatedly. What I need to accomplish is this,
    On the calculator sheet, select R2:R309
    Copy, paste transpose and as values to the Ex_Data_LBS data table in the Data sheet, the Upper left corner of the data table is A1
    On the calculator sheet, select S2:S309
    Copy, paste transpose and as values to the Ex_Data_KG data table in the Data sheet, the Upper left corner of the data table is KX1
    I need it pasted so that it expands the data table, not pasted just below.

    Thank you. I am having issues getting this to record.
    Attached Files Attached Files

+ 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] Macro to export word table data to excel
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2014, 09:45 AM
  2. [SOLVED] Need to Transpose and Flip Table of Data - Macro Probably Needed
    By BobTomlinson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 09:25 AM
  3. I would need a macro to export data from base example workbook to export worbook
    By slato8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 11:21 AM
  4. Export Excel data into Access table - overwrite table data
    By Jonsocks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-08-2012, 12:05 PM
  5. [SOLVED] Macro to transpose data to fill blank cells in table
    By nospaminlich in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2005, 06:05 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