Use macro to automatically copy/paste NEW data to another workbook?


I am trying to create a macro to copy and paste any new information into another workbook. The spreadsheet gets updated monthly, so each month I have to go in and copy and paste pieces of that data into another workbook. I am familiar with the copy/paste macro function, but is there a way to make one macro to update the new data?




By: Carah Granados

Leave a Reply

Your email address will not be published. Required fields are marked *