HI All! I'm still learning the ins and outs of VBA code, so I apologize if this is a simple thing to do...
Everyday I need to copy and paste the information from a few cells in one workbook to the cells of another workbook. The file names of these workbooks will change on a daily basis, however where the information appears on the sheets will be consistent. Also, even though the workbook file names will change on a daily basis, the sheet names in those workbooks will always remain the same. Workbook one (where cell values should be copied from) will be Live Intro and workbook two (where cell values should be pasted to) the sheet name will be ForArtist. Is there a way to determine a set range of cells to copy from one open workbook to another set range of cells on another open workbook? I'd love a code that I could assign to a button to streamline everything. (I'm using Excel 2011 for Mac)
Any and all help is greatly appreciated! Thanks!!
Bookmarks