Excel 2007 : Copy and Paste columns between files

[axe021]

Hi, I am new to macro and new to this forum. I have an excel sheet generated by a software with bunch of data. There are about 25 columns in there. I need a macro that will let me pick the columns that I want so that I can extract only the necessary columns. I need to create about 10 different sheets for 10 different companies from the same excel sheet but none of them require all the columns. So far I have been manually cpoying the columns and pasting it in another file for each company. Thats a pain, and i spend a lot of time just doing this. I would love to automate this with macro. Can someone please give me the codes for this or tell me what to do???

[JBeaucaire]

You actually may not need a macro. If your generated data sheet comes in the same format all the time (or even if it doesn't), it may be possible to structure some formulas on your permanent company sheets that just grabs the data it needs on its own.

Is it possible for you to upload a sample (10 rows or so) of data in a workbook with a couple of sheets for your companies that you're copying to? I might be able to help in that way.

If you don't want a 'realtime' update like that (which i would prefer) then a macro can be designed, but it would still be easiest if you give us a GOOD sample sheet to work from to write the macro.