Copy Workbook Values To Existing Workbook

  • Trust me when I say this is a last resort to ask for help. However, not being a VBA guy, I'm at a loss. I have figured out most of what I need, but i can't figure out how to make the following post only values. Every combination I use doesn't work. I'm sure it's something simple, and appreciate anyone who can help!!!


  • you could try something like this:


  • I wouldn't define a variable for the destination workbook in this case. ThisWorkBook will always refer to the workbook that contains the code.