macro to create a new workbook/ macro to copy columns
 

Hello,

I hope you guys can help me =)

I need a macro that once I press a button(Button1) (from developer's tab)
that I will be inserting to the worksheet, will create a new workbook with
the static name of "book1". I then need another button(Button2) with another
macro to copy columns 'A', 'C', 'D' and "O" from a sheet called "BOM" ( I
will have the buttons in a sheet called "Main" but need it to copy the data
from "BOM" as mentioned above). Now, Button2 will copy A C D O column to a
tab in the new WB and I want the new tab's name to be the name that is
located in "A15" in the "Main" WS. Now, once this is all done the user has
the ability to change things around in the "main" sheet that will change the
"BOM" sheet, I would like to have the ability to press Button 2 again and
have the new data in the "BOM" (ACDO) be entered in a new tab in the newly
created workbook and this could be done multiple times (as many as necessary).

Important Note: I need to only copy the values, I do not need the format and
i dont want the formulas Just Plain old Values..

Thank you very much and I hope you guys can help me out here,

TG