Macro to copy certain data from one workbook into another
Hi,
I'm looking for a macro to do the following:
Copy columns B, D, G, and J from my currently opened active workbook,
and paste as a new workbook, whose file name excel would prompt the user to
give.
Conditions: The pasted columns when pasted should be next to eachother as if
the unwanted columns were cut and cells shifted over ( A[b]C[D]EF[G]HI[J] =
BDGJ ). The formatting of the new cells should be exact as the formatting
from the previous workbook (same column widths, same colors, etc.)
Please help. Thanks in advance.
|