+ Reply to Thread
Results 1 to 1 of 1

How to Copy Specific Columns into a new Specific Worksheet?

  1. #1
    Registered User
    Join Date
    12-26-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question How to Copy Specific Columns into a new Specific Worksheet?

    Hey guys, I'm just new to Ms. Excel and VBA.

    What I want to do is to copy thousands data from (let's say) Column A,B,C,D,F,K,M, and O to a specific Excel file ("let's say D:/SBD/ABC.xls") and a specific column (it's like daily increment, so if yesterday day was started at column 24923, and today is 26231 or so). Is that possible if we copy a column into same type of data but the column is different (ex: when we have Item_Code column at the Column D, and we want to merge to the file mentioned before but in column F)?

    Can you please help me out? I found that's very frustrating we do same thing every day and it takes so much time to do it. Is this possible if we copy only the active cells on the sheet? The reason is because I have to do the same thing daily but, the amount of columns not always the same (let's say yesterday is 1282 columns and today is 1528 columns). Is that possible?

    NB: Sorry for my bad english and if i ask so much, I'm just a desperate employee. ):
    Last edited by aevo; 12-26-2013 at 11:26 PM.

+ 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. Copy a specific row and a range of columns to next available row on another worksheet
    By monkey1184 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 05:02 PM
  2. [SOLVED] Getting Unique Value, copy specific columns to another worksheet
    By EXCEL0429 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 09:02 PM
  3. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  4. [SOLVED] Macro code to Copy specific rows into specific columns
    By macrofan2012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2012, 11:24 AM
  5. 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

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