vba code to create multiple excel files in a folder and copy specific columns from master file to created excel files

[Pavithra devi]

Hello all,

Good day!!

I am a newbie to vba code, I want to create a vba code to create multiple excel files in an folder, and I have a master file specific columns has to be copied from that master file to created excel file!

Master File:
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H likewise till Column AC

I want to copy
Excel 1: Column A, Column B, Column C, Column D and Column E
Excel 2: Column A, Column B, Column C, Column D and Column F
Excel 3: Column A, Column B, Column C, Column D and Column G
Excel 4: Column A, Column B, Column C, Column D and Column H
Excel 5: Column A, Column B, Column C, Column D and Column I
Excel 6: Column A, Column B, Column C, Column D and Column J
.
.
.
.
..
Excel 25: Column A, Column B, Column C, Column D and Column AC


I hope to save a lot of time with this macro instead of manually copying and pasting data from master excel to different excel!

Please help me get through this!!

Thanks in Advance!!

 

[mumps]

What is the name of the sheet in the Master file that contains the columns to be copied? What is the full path to the folder where you want to save the new files and how do you want to name each new file?