This is an abreviated code of what I'm doing. I use a "Master" spreadsheet to enter info and upload other sheets. After "cleaning" up the other sheets, I open a new instance of Excel with the code above. But I can't figure out how to copy/cut a sheet from the original and paste it to the new one. Since the two workbooks are in seperate instances of Excel, normal copy/paste functions won't work. The reason I need the new one is that I need a "clean" start, with no macros, in the new one. Writing/making entries into cells from the "master" macros is pretty straightforward and easy, however; copying sheets isn't.
Bookmarks