Results 1 to 10 of 10

Copy/Paste Range to Another Range based on Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    39

    Copy/Paste Range to Another Range based on Criteria

    Please see attached workbook. I'm trying to copy the data in cells A5:E150 and paste them into their correct location (based on the month/year selected in the above cells). The matrix where these cells should be pasted begins at cell A200 and extends down/right (I plan to extend this archive of data to the year 2022). Please note: The data should not be pasted over existing data (i.e. someone accidentally selects January 2012, which has already pasted); so there should be a validation box asking something like "Are you sure you want to paste over the existing data for "Month","Year"?". If yes, then it proceeds to paste over the existing data, if No, then it cancels the macro.

    Also, I would like to recall prior data for a given year, as you can see a basic setup located in cell H1 and extending down/right. This is there so that the user can review data that was entered for prior months, given the selected year.

    Any help would be great...
    Attached Files Attached Files

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