+ Reply to Thread
Results 1 to 3 of 3

VBA Copy Paste Cuts From Source, Sends to Ether - Not To Destination Workbook

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    VBA Copy Paste Cuts From Source, Sends to Ether - Not To Destination Workbook

    Good afternoon!

    I am seeking help on how to get the terminated employees to the destination workbook. The employees are removed from the source workbook fine (FakeEmployees.xlsm), but never reach the destination workbook (FakeTerms.xlsm). They are both in the same directory location. I have examined the code and have researched but can't seem to grasp why it isn't reaching the destination. I set display alerts to true, but still nothing.

    Assumption is FakeEmployees is open to activate the macro to the closed file, FakeTerms.xlsm.

    Code is:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: VBA Copy Paste Cuts From Source, Sends to Ether - Not To Destination Workbook

    Hello,

    very little testing but:
    I ran your code on your worksheets, didnt see terminated employee in terms
    altered one line of code (see bold columns value in first line)
    Please Login or Register  to view this content.
    and it seemed to at least copy the one employee i terminated across to terms workbook

    Try it and see what happens

    jmac

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    Re: VBA Copy Paste Cuts From Source, Sends to Ether - Not To Destination Workbook

    So close! Thank you for that. My new issue, since the data is being put in the right place, is this process is overwriting the table headers in the destination sheet and making one of the term records the data headers. I have dependent worksheets that will not function if the data headers are overwritten. It looks like .AutoFilter.Range.Offset(1,0) should be moving the data down one row, is that not correct?

    Thanks!

    Jan

+ 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. Macro to copy and paste source file to destination file using cell value
    By mani88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2013, 10:16 AM
  2. [SOLVED] Unable to copy data from source excel to destination excel workbook
    By Lui23 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2012, 07:22 AM
  3. Get data from source workbook and paste to destination in change format
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2012, 01:47 AM
  4. Replies: 2
    Last Post: 01-22-2011, 01:24 PM
  5. how to copy succeeding rows from source workbook to destination w.
    By chris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2005, 10:06 AM

Tags for this Thread

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