A VBA routine to copy ‘source’ worksheets into a single ‘destina
- or -
Post a project like this1436
£30/hr(approx. $38/hr)
- Posted:
- Proposals: 6
- Remote
- #2820049
- Awarded
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
265698512373831792694227480440771404130546
Description
Experience Level: Intermediate
A VBA routine to copy ‘source’ worksheets into a single ‘destination’ workbook
The attached ZIP file, PPH127.ZIP, contains four workbooks:
Destination file:
1 PPH127_002.XLSM
Source files
2 Mailchimp1
3 Mailchimp2
4 Mailjet
PPH127_002.xlsm contains a single worksheet, Command which has a single command button, Loadworkbooksheets. It also lists three ‘source’ files.
Loadworkbooksheets is an empty .bas module. This project is to write the VBA code for Loadworkbooksheets that opens each of the three source files and then for each sheet in the source file to create a new worksheet in the destination file into which the worksheets in the source file are copied. The names of the worksheets created in the destination file can be named _ (from 0.. n).
Then return PPH127_002.XLSM which should contain the worksheets in the copied workbooks.
The job should be completed within 2 days of commissioning.
For a PPH developer familiar with manipulating Workbooks and worksheets this job should under 1 -2 hours.
The attached ZIP file, PPH127.ZIP, contains four workbooks:
Destination file:
1 PPH127_002.XLSM
Source files
2 Mailchimp1
3 Mailchimp2
4 Mailjet
PPH127_002.xlsm contains a single worksheet, Command which has a single command button, Loadworkbooksheets. It also lists three ‘source’ files.
Loadworkbooksheets is an empty .bas module. This project is to write the VBA code for Loadworkbooksheets that opens each of the three source files and then for each sheet in the source file to create a new worksheet in the destination file into which the worksheets in the source file are copied. The names of the worksheets created in the destination file can be named _ (from 0.. n).
Then return PPH127_002.XLSM which should contain the worksheets in the copied workbooks.
The job should be completed within 2 days of commissioning.
For a PPH developer familiar with manipulating Workbooks and worksheets this job should under 1 -2 hours.
Geoffrey R.
98% (48)Projects Completed
59
Freelancers worked with
44
Projects awarded
65%
Last project
4 May 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies