Selesai

Merge excel sheets and apply various formatting

Proyek ini berhasil diselesaikan oleh nwss1986 dengan harga $32 USD dalam sehari.

Dapatkan penawaran gratis untuk proyek seperti ini
Pemberi kerja bekerja
Anggaran Proyek
$30 - $250 USD
Diselesaikan Dalam
1 hari
Total Penawaran
45
Deskripsi Proyek

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

Ingin menghasilkan uang?

  • Atur anggaran Anda dan jangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran atas pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online