Write a VBA script: copy format between Excel files

Completed Posted 4 years ago Paid on delivery
Completed 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.

Excel Visual Basic for Apps

Project ID: #23440382

About the project

10 proposals Remote project Active 4 years ago

Awarded to:

shahinrahimi

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

$120 USD in 2 days
(52 Reviews)
5.3

10 freelancers are bidding on average $158 for this job

usmanhassan123

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

$200 USD in 1 day
(79 Reviews)
6.2
khanicha

Hello, I think it is better if the file in xlsm file, which contains: - vba code for exporting all style and format - worksheet template you need to export. So, when you load this . xlsm file it will export all for More

$150 USD in 1 day
(5 Reviews)
5.6
arash18k

Hi, I can develop a VBA script for you which is in an Excel file saved as .xlsm, in this way you will be able to edit the cod and all setting that we use to copying format. In this Excel file, you will be able to pick More

$200 USD in 7 days
(11 Reviews)
4.4
ssuet123

Hey there, Hope you are doing fine. I have been doing work in Microsoft scripting, VBA, formulas, graphs and dashboard creation using pivots, for the past 5 years. I can do this job perfectly for you if you share more More

$280 USD in 2 days
(3 Reviews)
2.5
ginius123

i am ready to your work i have best employees and best management best environment work accuracy 95%

$130 USD in 6 days
(0 Reviews)
0.0
faizurrahmanfrr

Good at it Relevant Skills and Experience Data entry, excel, sreadsheet.....

$155 USD in 3 days
(0 Reviews)
0.0