Results 1 to 11 of 11

macro to copy data to specific columns in same workbooks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,139

    macro to copy data to specific columns in same workbooks

    Hi All

    I have a workbook with several sheets, sheets breakdown contains data with formula

    however need a macro to automate it insert upload sheet in same workbook

    That is
    breakdown sheet row 2 column B2 and C2 are copied to upload_1 sheet column C and D staring at row 2 still to last data row paste special values only

    breakdown sheet row 2 columns D2 are copied to upload sheet_1 columns I2 starting at row 2 still to last data row paste special values

    breakdown sheet row 2 column G2 and H2 are copied to upload_1 sheet column L2 and M2 AT ROW 2 still to last data row paste special values

    breakdown sheet row 2 column I2 are copied to upload_1 sheet column B2 AT ROW 2 still to last data row paste special values

    breakdown sheet N2 to O2 COPIED to upload_1 sheet A1

    breakdown sheet R2 COPIED to upload_1 sheet E1

    breakdown sheet S2 to T2 COPIED to upload_1 sheet J2 TO K2 and autofill to last data row

    breakdown sheet U2 COPIED TO upload sheet A2 AUTOFILL TO LAST DATA ROW

    The data reads more than 5000 rows.

    Thanks for assistance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 05-04-2015, 05:13 PM
  2. Macro to copy data from specific columns and paste to new workbook
    By jcs2811 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2014, 10:15 PM
  3. Macro to copy data from specific columns and rows to new worksheet.....
    By dleckie in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-19-2014, 10:16 PM
  4. Macro to copy values from specific columns from different workbooks to one sheet
    By sksajid7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-11-2013, 09:50 AM
  5. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  6. Macro to copy specific data to specific columns from a pivot table
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2012, 07:24 PM
  7. Copy specific columns from mult workbooks to seperate workbook
    By excelgrrl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2009, 10:12 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