Thanks in advance for taking a look at my problem.

In the Excel file there are several worksheets. The first worksheet named "Industries" is where I drop my raw data from the web. The subsequent worksheets contain the data sorted with various filters. I have a macro to reapply the filters to all the worksheets after new data is entered in “Industries”.

I would prefer to copy the data...just the values and paste them to PowerPoint presentation. I only want to copy visible data from any of the columns where data is being copied. The number of rows of data will vary each time on all the worksheets.

On the Job's worksheet there data in column L and N that I want to transfer to a table in PowerPoint slide 2 presentation file. I would prefer to just copy and paste the data to an existing table in PowerPoint file presentation slide 2. I have the data formatted in Excel and I just want to copy to PowerPoint slide 2 into the existing table.

I want to copy the values from the "Change" worksheet in column L and O to a table in PowerPoint slide 3. Not the headers. The headers already exist in the destination table on slide 3.

I want to copy the values from "LQ>1.2" Column L to O to a table on slide 5. The number of rows of data will vary each time. Not the headers.

I want to copy the values from "LQ<0.8" column L to O to a table on slide 6. Not the headers.

I want to copy the text from Competitive Strength worksheet column L to PowerPoint slide 8. Not the header.

I want to copy the text from Important to Retain worksheet column L to PowerPoint slide 11. Not the header.

I want to copy the text from Competitive Weakness worksheet column L to PowerPoint slide 14. Not the header.

I want to copy the text from Emerging Industries worksheet column L to PowerPoint slide 15. Not the header.

I want to copy the values from "4 Level NAICS LQ>1.2" columns K through O to tables on slides 19 onward with 15 rows of data on each slide. Not the headers. The destination tables already contain headers.