+ Reply to Thread
Results 1 to 10 of 10

Macros. Range. Copy.

  1. #1
    Registered User
    Join Date
    10-17-2019
    Location
    Douglas
    MS-Off Ver
    2007
    Posts
    4

    Macros. Range. Copy.

    Hello society!
    Help is needed. There is an array of data: 9 columns, rows already over 2000. Every day new data arrives - date (date format), time (time format) and 7 different parameters (number format). I need to copy 24 rows (except the last) and paste into another sheet for analysis. I created a Macros, but he Macros constantly copies data from the same cells. I cannot enter a new range in the Macros "Range". Tell me how to make sure that the macro copies only 24 penultimate lines all the time, even when more and more new lines are added. Thanks in advance.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Macros. Range. Copy.

    Something like:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Macros. Range. Copy.

    Somethink like this:
    Please Login or Register  to view this content.
    Last edited by PaulM100; 10-17-2019 at 08:46 AM.
    Click the * to say thanks.

  4. #4
    Registered User
    Join Date
    10-17-2019
    Location
    Douglas
    MS-Off Ver
    2007
    Posts
    4

    Re: Macros. Range. Copy.

    Thank you so much!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Macros. Range. Copy.

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Macros. Range. Copy.

    Or another possibility. Change sheet reference as required.
    Please Login or Register  to view this content.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Macros. Range. Copy.

    Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  8. #8
    Registered User
    Join Date
    10-17-2019
    Location
    Douglas
    MS-Off Ver
    2007
    Posts
    4

    Re: Macros. Range. Copy.

    Thamks to everybody. SOLVED!

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Macros. Range. Copy.

    You're welcome.


    See post #7 for how to mark the thread as solved.

  10. #10
    Registered User
    Join Date
    10-17-2019
    Location
    Douglas
    MS-Off Ver
    2007
    Posts
    4

    Re: Macros. Range. Copy.

    Hello, everybody,
    Help is needed.
    Please, how to write a formula for calculating a polynomial of degree 9?
    Sinverely.

+ 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. VBA Macros to copy dynamic range from 1 sheet to another
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2018, 10:37 AM
  2. [SOLVED] VBA Macros to Copy data from closed workbook specific range
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2016, 11:35 AM
  3. Copy some specific range in first empty row with macros
    By Prinzboldi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2015, 09:27 AM
  4. Use Macros to copy and paste transpose through a range of data
    By zxchan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-12-2013, 04:17 AM
  5. Replies: 4
    Last Post: 03-09-2012, 10:54 AM
  6. Automatically Changing Copy Range in Macros
    By jfoote in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-25-2009, 02:05 PM
  7. Replies: 2
    Last Post: 09-24-2005, 08:05 PM

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