sedang Berlangsung

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

Keahlian Excel, Visual Basic untuk Aplikasi

Lihat lebih lanjut: macro excel merge sheets, excel merge sheets, excel merge duplicates, budget format excel sheet, 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

Tentang Pemberi kerja:
( 101 ulasan ) norwalk, United States

ID Proyek: #11708071

Diberikan kepada:

nwss1986

Hi.can 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 spreadsheet.all that ha Lagi

$32 USD dalam 0 hari
(15 Ulasan)
3.4

43 freelancer menawar pada rata-rata $239 untuk pekerjaan ini

$175 USD dalam 1 hari
(245 Ulasan)
7.6
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 Lagi

$400 USD dalam 5 hari
(153 Ulasan)
6.3
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 Lagi

$250 USD dalam 5 hari
(105 Ulasan)
6.2
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 Lagi

$100 USD dalam 1 hari
(161 Ulasan)
5.7
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 Lagi

$250 USD dalam 2 hari
(82 Ulasan)
5.9
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 Lagi

$250 USD dalam 5 hari
(52 Ulasan)
5.5
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 dalam 2 hari
(60 Ulasan)
5.0
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. Lagi

$194 USD dalam 3 hari
(38 Ulasan)
5.5
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 Lagi

$250 USD dalam 3 hari
(50 Ulasan)
5.2
andriphone0

Hi, Please refer to your PM, So we can create some sample work before awarding the project so that you can have a idea about the Quality of our work. I have read description carefully and I understand your projec Lagi

$50 USD dalam 1 hari
(38 Ulasan)
5.0
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 Lagi

$250 USD dalam 10 hari
(15 Ulasan)
4.1
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 Lagi

$300 USD dalam 3 hari
(23 Ulasan)
4.8
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 Lagi

$80 USD dalam 2 hari
(16 Ulasan)
3.5
$30 USD dalam 3 hari
(11 Ulasan)
3.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 dalam 10 hari
(4 Ulasan)
3.3
$50 USD dalam 2 hari
(7 Ulasan)
2.9
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 Lagi

$155 USD dalam 4 hari
(3 Ulasan)
2.7
hialok78

I am a Project Manager in profession working at one of the world's largest I.T. firms. I have more than 10 years of experience in academic writing and Data Entry and ensure that quality work is delivered always. Give m Lagi

$250 USD dalam 3 hari
(2 Ulasan)
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 Lagi

$255 USD dalam 10 hari
(5 Ulasan)
2.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 Lagi

$419 USD dalam 5 hari
(3 Ulasan)
1.6