VBA to Paste select columns based on Criteria in

[Mr.Bigz]

I am trying to automate a report. There are 2 tabs to populate with data "Interior Material Outage" and "CP Material Outage". The data needed to populate the two tabs is on the "Inventory Control" tab.

If Column A on the "Inventory Control" tab says "Interior" and column EV says "Outage", then that row of data goes on the "Interior Material Outage" tab. If Column A says "CP" and column EV says "Outage", then it goes on the "CP Material Outage" tab.

Only the information with the dark orange header and white text need to be transferred over to the outage tabs.

***There are data validation options in column B of the Outage tabs. This needs to remain.


I've also created part of a Macro to populate some data on the Inventory Control tab in the beginning. If there is a better way to write it, feel free to do so.

Please Login or Register  to view this content.

[Mr.Bigz]

I had to shrink down the sample file. Column AK has the "outage" comment to determine if it goes on an outage tab.

Columns on the "Inventory Control" tab that need to be transferred over are filled with orange with white text.