Results 1 to 3 of 3

Copy/Paste Dynamic Range

Threaded View

RedStick Copy/Paste Dynamic Range 05-28-2014, 02:31 PM
RedStick Re: Copy/Paste Dynamic Range 05-28-2014, 02:49 PM
BS Singh Re: Copy/Paste Dynamic Range 05-28-2014, 03:38 PM
  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    2

    Copy/Paste Dynamic Range

    Hello,

    I have a range of cells with data from one day. This range is "C36:K63"

    Each day, the prior day's range needs to be copied and pasted into a new range that begins two rows below where the prior day's range ends.

    Thus, day two should copy "C36:K63" into a new range: "C65:K92"

    As you can tell, the rows will change each day, but the columns will always remain the same.

    How can I create a macro that allows a user to copy data from the most recent range and paste it into a new range?

    i.e. if there is no data in C65:K92, the macro should copy the data from C36:K63 and paste it into C65:K92. Then, the next day, the macro would copy the data from C65:K92 and paste into C94:K121.

    Thanks in advance,

    RS
    Last edited by RedStick; 05-28-2014 at 02:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need dynamic range select and copy Paste
    By rags_rags in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 03:49 PM
  2. [SOLVED] Copy and Paste Dynamic Range
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2013, 11:14 AM
  3. Dynamic offset range copy/paste
    By elxan0611 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2010, 04:45 AM
  4. Copy dynamic range from previous sheet and paste after last used row in a range
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2010, 06:24 PM
  5. Copy and paste dynamic range
    By wpryan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2010, 09:42 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