+ Reply to Thread
Results 1 to 2 of 2

Copying Non-Contiguous columns from workbook to the active workbook

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Cairo,Egypt
    MS-Off Ver
    2010
    Posts
    75

    Copying Non-Contiguous columns from workbook to the active workbook



    Dears,

    Please I need your support as I need to modify the attached code in Pic as I need to copy the data which I will extract from the source file to the last blank cell which will be located after the date cell and all what I need is to only copy the data which will be in column A & C (from the source file) not from A to C and paste it in the destination file.

    Thanks in advance
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by Mohamed Hassan; 10-09-2019 at 03:09 AM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Copying Non-Contiguous columns from workbook to the active workbook

    Possibly...
    Please Login or Register  to view this content.

+ 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 Select Columns from closed workbook into active workbook
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-09-2015, 02:04 PM
  2. [SOLVED] Trouble copying data from closed workbook into active workbook, referencing help
    By lepperga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2013, 01:48 PM
  3. [SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 08:25 AM
  4. [SOLVED] COPY from an open workbook with particular sheet and columns to active workbook
    By purin0c0 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2012, 03:57 PM
  5. Copying Worksheets from Open Workbook to Active Workbook
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2011, 08:32 PM
  6. Copying a sheet from .xla to new or active workbook
    By MarMo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2010, 05:29 AM
  7. Questions on copying range from closed workbook to active workbook
    By stevebriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2007, 09:45 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