Excel VBA Work - Filter Pivot, Copy, Paste, save as new File
$10-30 USD
Completed
Posted over 9 years ago
$10-30 USD
Paid on delivery
I need help to write a macro which will:
- Filter 3 seperate pivots with different data sources based on the same filter criteria (i.e. all have same supplier number)
- Copy the pivots and other defined cell data
- Open the blank workbook template
- Paste in the data from the 3 pivots as well as other additional cell data
- save the template with a new name using the supplier name
- Repeat and use the next supplier.
Ultimately the macro will create a new workbook for each supplier based on a template and fill it with data from a master data source.
Note that this is for dummy data, and i will take the macro and use it for the real data so please add comments in the macro which can help me understand what's going on. e.g. "This is saving the file in this file location"
Sir,
I am well versed in this kind of jobs and can do your project as per requirement.
I have done lots of these kind of projects and will deliver flawless work
Looking for further discussions in this regard.
with thanks and regards
I am expert in excel and excel macros and worked on several complex features. I would like to work with you.
Please let me know further.
Regards,
Selvan
Hi
I'm an IT student with good knowledge in excel and can help you to do your job.
Please check my review and my portfolio and let me know if you interested to work with me.
I will promise to do my best and I have very good experience in this field.