how to copy specific data from one workbook to multiple workbooks

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.

I run reports from our reporting program. I paste the data into 'SHEET1" of the "Performance Summary.xlsm" file.
I then run a macro the performs 'Text to Columns' function. It then moves the data to the appropriate tabs.
This works as I need it to. But now I need to add onto the macro to copy/paste the data to other workbooks.
Here is the code for the current macro:

Please Login or Register  to view this content.

I have 2 workbooks attached.

If you open the "Performance Summary.xlsm" file you will see a separate tab for each company.

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

Each Company tab has the following headers:
CUSTOMER
DATE
TIMEFRAME
APPROVALS
APPROVALS IN 'STAND-IN'
DENIALS
APPROVAL
PERCENTAGE

I need the data in the 'APPROVALS' and 'DENIALS' columns only copied and then pasted into another workbook.

The workbook that I need the data pasted into is named "Trending & Alerting". There is a separate workbook named "Trending & Alerting" for each company name.

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

Within the "Trending & Alerting" workbook, there is a tab for each month of the year(Jan., Feb, Mar. etc.)

If you open the "Performance Summary.xlsm" file and look at the Company One tab, I highlighted the text in "RED" to show what is need to be copied.

If you open the "Company One Trending & Alerting.xlsm" file and look at the April tab, I highlighted the text in "RED" to show what is need to be pasted.

Any help would greatly be appreciated.

Hi,

I didn't go through your entire post. But this might be a useful one.