+ Reply to Thread
Results 1 to 6 of 6

Limit copy range baised on visible data

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Limit copy range baised on visible data

    I have a worksheet that lists data in a table to be added to a "Jobs Log". The table consists of 13 rows all populated from formulas.

    The code as shown will copy the data but if some rows are blank and only contain empty formula values, they also get copied. When I add more data it looks for the next available row and that may be many rows below the last visible set of data.

    I am looking for a way to copy only the data that is visible and not include blank formulas. I also need to add 6 lines of code to copy formulas from the preceding rows. Those Columns are "K","M","AH","AI","AM", and "AX" (11-13-34-35-49 & 50 respectively). I am not sure how to add the necessary code for these changes.

    Please Login or Register  to view this content.
    Thanks

    Jim O
    Last edited by JO505; 04-22-2013 at 03:16 PM.

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Limit copy range baised on visible data

    Hi Jim O

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the "Add Files"... button to locate your file for uploading.
    6. This will open a new window File Upload...Click "Select Files"
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the "Upload Files" button and wait until the file has uploaded.
    10. Click the "Done" Button.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Limit copy range baised on visible data

    jaslake,

    Thank you for your response. Attached is a mockup of the file. If you have any further questions let me know.

    Jim O
    Attached Files Attached Files

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Limit copy range baised on visible data

    Hi Jim O

    Try this Code
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Limit copy range baised on visible data

    Beautiful!!

    Thank you very much for your assistance.

    Jim O

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Limit copy range baised on visible data

    You're welcome...glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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