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...
Bookmarks