Excel VBA to merge files [closed]
Multi tool use
I have a template that I fill with information for a group of 10 agents. After they work on them i end up compiling them in a single file and im looking for a VBA code to automate this task.
Each file has exactly 5 sheets called Fin Class, Newest AR, Quadax Denials, Daily Log and Ins AR Summary.
The sheets i copy and paste into a single file are only 3: Newest AR, Quadax Denials and Daily Log as these contain the accounts agents worked on during the month.
So I need a macro to do the following:
Look inside a user defined path
Copy Newest AR sheet from all 10 files and paste them on a single sheet (This goes from Columns A:AF, last row can vary, so each sheet needs to be pasted where the last one ended.
The same for sheet called Quadax Denials (columns A:T) and,
Daily Log (columns A:Q).
microsoft-excel-2013
edited Dec 12 at 5:53
Mureinik
2,31751525
asked Dec 11 at 22:31
FvFo
61
closed as off-topic by Ƭᴇcʜιᴇ007, Dave, fixer1234, Burgi, bertieb Dec 12 at 11:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – Ƭᴇcʜιᴇ007, Dave, Burgi
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have a template that I fill with information for a group of 10 agents. After they work on them i end up compiling them in a single file and im looking for a VBA code to automate this task.
Each file has exactly 5 sheets called Fin Class, Newest AR, Quadax Denials, Daily Log and Ins AR Summary.
The sheets i copy and paste into a single file are only 3: Newest AR, Quadax Denials and Daily Log as these contain the accounts agents worked on during the month.
So I need a macro to do the following:
Look inside a user defined path
Copy Newest AR sheet from all 10 files and paste them on a single sheet (This goes from Columns A:AF, last row can vary, so each sheet needs to be pasted where the last one ended.
The same for sheet called Quadax Denials (columns A:T) and,
Daily Log (columns A:Q).
microsoft-excel-2013
edited Dec 12 at 5:53
Mureinik
2,31751525
asked Dec 11 at 22:31
FvFo
61
closed as off-topic by Ƭᴇcʜιᴇ007, Dave, fixer1234, Burgi, bertieb Dec 12 at 11:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – Ƭᴇcʜιᴇ007, Dave, Burgi
If this question can be reworded to fit the rules in the help center, please edit the question.
1
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09
add a comment |
I have a template that I fill with information for a group of 10 agents. After they work on them i end up compiling them in a single file and im looking for a VBA code to automate this task.
Each file has exactly 5 sheets called Fin Class, Newest AR, Quadax Denials, Daily Log and Ins AR Summary.
The sheets i copy and paste into a single file are only 3: Newest AR, Quadax Denials and Daily Log as these contain the accounts agents worked on during the month.
So I need a macro to do the following:
Look inside a user defined path
Copy Newest AR sheet from all 10 files and paste them on a single sheet (This goes from Columns A:AF, last row can vary, so each sheet needs to be pasted where the last one ended.
The same for sheet called Quadax Denials (columns A:T) and,
Daily Log (columns A:Q).
microsoft-excel-2013
edited Dec 12 at 5:53
Mureinik
2,31751525
asked Dec 11 at 22:31
FvFo
61
I have a template that I fill with information for a group of 10 agents. After they work on them i end up compiling them in a single file and im looking for a VBA code to automate this task.
Each file has exactly 5 sheets called Fin Class, Newest AR, Quadax Denials, Daily Log and Ins AR Summary.
The sheets i copy and paste into a single file are only 3: Newest AR, Quadax Denials and Daily Log as these contain the accounts agents worked on during the month.
So I need a macro to do the following:
Look inside a user defined path
Copy Newest AR sheet from all 10 files and paste them on a single sheet (This goes from Columns A:AF, last row can vary, so each sheet needs to be pasted where the last one ended.
The same for sheet called Quadax Denials (columns A:T) and,
Daily Log (columns A:Q).
microsoft-excel-2013
microsoft-excel-2013
edited Dec 12 at 5:53
Mureinik
2,31751525
asked Dec 11 at 22:31
FvFo
61
edited Dec 12 at 5:53
Mureinik
2,31751525
asked Dec 11 at 22:31
FvFo
61
edited Dec 12 at 5:53
Mureinik
2,31751525
edited Dec 12 at 5:53
Mureinik
2,31751525
edited Dec 12 at 5:53
Mureinik
2,31751525
2,31751525
asked Dec 11 at 22:31
FvFo
61
asked Dec 11 at 22:31
FvFo
61
asked Dec 11 at 22:31
FvFo
61
61
closed as off-topic by Ƭᴇcʜιᴇ007, Dave, fixer1234, Burgi, bertieb Dec 12 at 11:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – Ƭᴇcʜιᴇ007, Dave, Burgi
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by Ƭᴇcʜιᴇ007, Dave, fixer1234, Burgi, bertieb Dec 12 at 11:03
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – Ƭᴇcʜιᴇ007, Dave, Burgi
If this question can be reworded to fit the rules in the help center, please edit the question.
1
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09
add a comment |
1
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09
1
1
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
I2WxEcgulGJ4nVsVIt2Udi0f2y,y
1
Show what you have done please. Then we can see where it has gone wrong
– Dave
Dec 12 at 6:09