Copying specific columns

I'd like to, but unfortunately this is only one copy/paste routine of many. From the source data I run multiple filters, and for each one copy the results to another worksheet. I wind up using most of the columns at one point or other, so can't delete them as I go. For each Filter, I only need 7 or 8 pertinent columns to copy with.

For my first autfilter, I autofilter on column M, then I need to copy columns A, F, M, and G

For my next autofilter, I autofilter on column x, and need to copy A, J, K, L, R and X.

Next is D, need to copy B, C, F, S, T and I

And so on, and so forth. There's no real logic to it, except that the data in these columns goes together (IE if I'm pulling Employee Names, I want their phone number and home and office locations with it. If I'm pulling Mail Codes I'd want the employee name, supervisor name, and office location with it. Sometimes I need location code, sometimes I need position function title, sometimes position function code, sometimes job title, sometimes job code, sometimes hire dates, sometimes employee id, etc.)

So, I need a way to be able to plug into my macro for each step what columns I need to copy. Otherwise I'm copying all of that data every time, and don't need it all, as each autofilter step is for a different select audience.

Dave,

I agree Access would be better, but we're limited to Excel on this one.

I haven't tried your routine, because the "deleting columns" part concerns me. Here's the gist:

All of my autofilter copy/paste routines happen in the same sapn of time, from my users hitting a "Go" button in a workbook I've devised. That workbook pulls from 2 other workbooks, the APR and the ESS. I can't delete from either the APR or the ESS because a later autofilter copy/paste will need one of those columns being deleted.

The data is copied into one single report, with instructions and explanations before and after telling my users what to do with each set of information. In some cases, they'll mail off the data, some they'll take care of themselves, etc. So I can't delete columns in this report either, because I might delete needed data from another report run earlier.

As I said, I haven't tried your routine yet, so if it's NOT going to be deleting columns let me know. .

Sorry I never replied, got pulled away on other projects. We can't use Access because of turnover. Huh? Here's how it works:

Employee Bob gets hired on, full of ideas on how to remake the world. He meets the workerbees, and sees them struggling to make Excel do a job that Access is made for. Bob says "I can do that with an Access database!". So, he makes one up, teaches everyone how to use it. There's a big party with cake and cookies, and everybody is thrilled by the new database. Then Bob gets a wild hair and moves to Katmandu to contemplate his navel. Something in the data changes and the database quits running. The workerbees, proficient in Excel but not knowing anything about Access, are stumped. So, they go back to Excel, except they have to refigure out how they were doing it before. A year later, Fred gets hired on, full of ideas on how to remake the world, looks around and says "I can do that with an Access database"....

That's why we're not allowed to use Access.