In Progress

Merge excel sheets and apply various formatting

Need excel vba code to perform the following:

Excel form should accept two spreadsheet names and:

Create new spreadsheet

from spreadsheet #1, copy cells a1 through end of spreadsheet (column i) to new spreadsheet

from spreadsheet #2, copy cells a3 through end of spreadsheet (column i) to new spreadsheet

delete column H

adjust column A width to 13

insert new column A

format column A as "short date"

add formula to A3 - =IF(ISBLANK(D3),B3,D3)

copy forumula down to end of data

sort by column A for A3 to end of data, descending

Add text "Adjusted SOL date" to A2

Add blank line between each row starting at A3

Set print area to entire table

Set print width to entire column width

adjust I column width to 47

Set all cells to top align

Set row height to auto for all rows (may not be necessary)

Sample spreadsheets will be provided

Skills: Excel, Visual Basic for Apps

See more: macro excel merge sheets, excel merge sheets, script excel merge excel files, excel merge duplicates, budget format excel sheet, excel merge company names different spreadsheets, excel merge files, budget format excel, excel merge info spreadsheets, vbscript excel merge, format excel data sheets, excel merge tab delimted, format excel sheets, excel merge data photoshop, excel merge files mail duplicates

About the Employer:
( 101 reviews ) norwalk, United States

Project ID: #11708071

Awarded to:

nwss1986

[url removed, login to view] you please send me the sample spreadsheet?i can start right now and can deliver to you in few hours. In fact, i have vba code ready for all the specs posted by you right from creating new [url removed, login to view] that ha More

$32 USD in 0 days
(40 Reviews)
4.5

42 freelancers are bidding on average $243 for this job

$175 USD in 1 day
(252 Reviews)
7.6
KulfiSoftwares

ZERO ERROR GUARANTEED!! Please read my reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied wit More

$250 USD in 2 days
(140 Reviews)
6.7
bdmultitech

Hello, Expert here. Ready to start immediately. Having read the outline given I am positive I can be of great value for the tasks at hand. Let me do this work with perfection, accuracy and according to your require More

$400 USD in 5 days
(180 Reviews)
6.5
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel macros and i've never had a single problem. If you are interested, send me a sample sheets (both input and More

$100 USD in 1 day
(292 Reviews)
6.4
gayuh

Hi! I would like to offer my service to merge excel sheets and apply various formatting. I am a programmer for client/server, web & mobile applications. Proficient in Office VBA, Microsoft .NET + MS SQL Server, P More

$250 USD in 5 days
(90 Reviews)
5.9
facebooklikes007

Hi, After reviewing the details of your project, I understood and highly interested in your project. I am guaranteeing you that you will get 100% satisfactory result. Please send us the details to do a Sample More

$250 USD in 5 days
(105 Reviews)
6.3
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$80 USD in 2 days
(84 Reviews)
6.0
nagyzoltan68

Hello , I would like to work on your project. I have great experience using excel and macros / vba. I would like to work directly on your sample file as you have mentioned this will be provided. Regards

$100 USD in 2 days
(84 Reviews)
5.7
oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss............. Choose wisely!! Cheers :)

$250 USD in 1 day
(36 Reviews)
5.2
Rajni0802

Hello, I can manage this formatting task in excel sheet as well as word documents as per your requirement. Let's discuss further. - I can manage lead generation, web researching and lead list building - I can manag More

$250 USD in 3 days
(64 Reviews)
5.5
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$194 USD in 3 days
(40 Reviews)
5.6
Saidul28

Hello, I am Saidul . I am expert in Data entry work. I have read your project details and I am a hard worker; I feel that I work quickly and concisely with little direction. I have excellent skills in all Microsoft More

$250 USD in 10 days
(22 Reviews)
5.1
$30 USD in 3 days
(31 Reviews)
4.7
subhashkadwashra

Hello I believe in quality work that meet the clients Expectations and satisfied the clients. I would like to work on this project, as I understand your project requirement very well, I can do it as per your Expecta More

$300 USD in 3 days
(29 Reviews)
5.0
BAVarun

Most of the reviews on my profile are for excel. I come with an experience of over 15 years in excel and contributor to various sites, where users post queries related to excel. I am efficient in creating macros an More

$155 USD in 4 days
(31 Reviews)
4.5
$50 USD in 2 days
(22 Reviews)
4.5
humayoonsheikh4u

Dear Sir, I am an EXCEL expert having hands on expertise on all types of advanced excel function i will do your project as per your requirement. Best regards

$502 USD in 10 days
(8 Reviews)
3.9
umeshj1982

Hi, My name is Umesh Joshi & I would like to know the details of the project. I have more than 8 years of experience in the field of Data Processing & Data Management So would request you to provide more details More

$250 USD in 10 days
(10 Reviews)
3.0
cracken

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirement More

$419 USD in 5 days
(4 Reviews)
2.0
sadaqatali408

Hi I have read out all the description given in your project and I am fully capable to deliver this Project with 100% accuracy and according to your instructions. I have worked on many projects similar to this in the More

$255 USD in 10 days
(8 Reviews)
2.3