Write a VBA script: copy format between Excel files
$30-250 USD
Paid on delivery
I regularly create tables in a statistical software and often export them as Microsoft Excel files to share them with my colleagues.
Due to modification on the upstream analysis, I sometimes need to export Excel files with virtually identical formats, but different values.
The problem is that I need to MANUALLY format the Excel file every time I export tables, hence this project.
I am seeking someone who can write a VBA script which accomplishes the following:
1. On a GUI, asks existing Excel file A, a worksheet in it X, and a worksheet Y in the Excel file in which the VBA resides.
2. Reads the format of worksheet X.
3. Applies the above format to worksheet Y.
I assume loading the VBA script, saved as a .vb file, using Microsoft Visual Basic for Applications executed from Excel's "Development" tab - "Visual Basic". I do understand that an alternative can be to create a single executable file from the VBA, but I prefer running a .vb file for possible future modifications.
The Excel files have the following constraints. It will be OK as long as the VBA script works within these.
1. The first row contains column names. Every column has a column name. No blank.
2. The second and lower rows all contain data. Characters or numbers. Data can be blank (missing values).
3. Formatting options that I regularly use are:
- Column width
- Cell Format
- Conditional formatting
- Scroll lock
- Page layout
- Sort
However, copying ALL the formatting options is the requirement of this project. Please let me know in advance if you believe it makes sense to restrict the type of formatting options to copy for fast execution, etc.
4. The file does NOT contain: hyperlinks, pivot tables, graphs, diagrams, pictures, comments, form controls, scripts.
Columns must be matched using the value of the first row. This is because I sometimes add or delete columns in the statistical software. Failure to match renamed columns is OK.
Please forgive me when there is any incorrect wording of Excel's features here.
Project ID: #23440382
About the project
Awarded to:
Hi, Good day... I can help you with easy formatting option as you describe, I can write you neat VBA code to handle all your formating problem and speed up your workflow. I have rich experience in VBA-Macro(Excel, Powe More
10 freelancers are bidding on average $158 for this job
I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) and Power Bi dashboards development. I already done many projects of: • Excel Automation. • Exce More
i am ready to your work i have best employees and best management best environment work accuracy 95%