Pavithra devi
New Member
- Joined
- May 14, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
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!!
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!!