VBA to Copy a Workbook to another Spreadsheet

[LesGrimes389]

Hi Friends,

as expressed in some previous posts, I'm very new to VBA and am definitely trying to punch above my limited knowledge at the moment, you help one person in the office, then you are an expert!!

I have two documents, Supplier OPS KPI and NON Conformance.

Within the NON Conformancen document (which I have set up a User Form against), I would like to copy all of the data from a workbook (tab) called 'Hotel KPI' to a tab within the document Supplier OPS KPI.

Every example of the code I have found online leads to a '9' error or something similar.

Does anybody have an example of the code I need to make this work?

Also, as the Hotel KPI tab is always being added to on a daily basis, is it possible to ensure that when the Macro is run, it doesn't keep creating a new workbook within the Supplier OPS KPI but just updates the existing tab?

Sorry for the vague-ness of this post, I hope someone can help

[TMS]

Welcome to the forum

Best bet ...

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.