how to specific copy data from one workbook to multiple workbooks

[iamasimpleman]

I have a workbook named "Performance Summary.xlsm". This file contains a tab for each company.

Name of the tabs:
Company One
Company Two
Company Three
Company Four
Company Five
Company Six
Company Seven
Company Eight


There is also a separate workbook named "Trending & Alerting" for each company. Within workbook, there is a tab for each month (Jan., Feb, Mar. etc.)

So the "Trending & Alerting" workbooks are named:

Company One Trending & Alerting.xlsm
Company Two Trending & Alerting.xlsm
Company Three Trending & Alerting.xlsm
Company Four Trending & Alerting.xlsm
Company Five Trending & Alerting.xlsm
Company Six Trending & Alerting.xlsm
Company Seven Trending & Alerting.xlsm
Company Eight Trending & Alerting.xlsm

I would like the macro that I can run from the "Performance Summary" workbook.

The macro would need to be able to copy the "APPROVALS" and DENIALS" columns from each tab of the "Performance Summary" workbook.

Then open the "Trending & Alerting" workbook for that company, paste this information into the "Trending & Alerting" workbook. Save and close the workbook.

I would need this to do this for each tab of the "Performance Summary" workbook.

This information is based on the Company Name, Date and Timeframe found in the "Performance Summary.xlsm".

I highlighted the text in "RED" to show what is need to be copy/pasted.
Any help would greatly be appreciated.

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.