Merge excel sheets and apply various formatting

  • Status Diselesaikan
  • Anggaran $30 - $250 USD
  • 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

Dapatkan penawaran gratis untuk proyek seperti ini
Diselesaikan oleh:
Keahlian yang Diminta

Ingin menghasilkan uang?

  • Atur anggaran Anda dan kerangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran untuk pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

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