Completed

Merge excel sheets and apply various formatting

This project was successfully completed by nwss1986 for $32 USD in a day.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
45
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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