+ Reply to Thread
Results 1 to 3 of 3

Copy and paste macro results in a large size file

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Copy and paste macro results in a large size file

    The macros in the attached file do as they should. The only issue is that the Copy_Filtered() and Copy_Filtered2() macros copy too much that is needed and when pasting to another tab results in a larger file size.

    Macros: FILTER
    Filters the data in the BEA Dump tab by criteria. Once it is filtered, it calls Copy_Filtered() which should only copy the filtered data. However, it copies from B3 and every visible cell.
    Than, filtered data is unfiltered and filters again by different criteria. Once it is filtered, it calls Copy_Filtered2() which should only copy the filtered data. However, it copies from B30 and every visible cell.

    This overlap and the pasting of all I feel is resulting in a larger file size. What I would prefer is that the Copy_Filtered() and Copy_Filtered2() macros only copy/paste the filtered data respectively.

    I've tried to find a way, but have not resolved the situation. Can someone look into the macros and see how that can be resolved?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy and paste macro results in a large size file

    I have assumed that you want to copy the heading in sheet BEAM, but if you do not want to copy it, change B4 in to B5
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Re: Copy and paste macro results in a large size file

    AB33, that worked perfectly. My file went from 4,245KB to 2,933 KB... thanks so much....

+ 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. Replies: 2
    Last Post: 02-08-2012, 11:57 AM
  2. Large File Size
    By ems.payroll in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2008, 02:50 PM
  3. Replies: 1
    Last Post: 10-17-2005, 04:05 AM
  4. why is the size of my file so large?
    By stevej12 in forum Excel General
    Replies: 4
    Last Post: 05-24-2005, 01:06 PM
  5. Replies: 0
    Last Post: 02-03-2005, 05:39 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