Simple Macro Programme for excel

IN PROGRESS
Bids
53
Avg Bid (GBP)
£16
Project Budget (GBP)
£10 - £20

Project Description:
I have a process I repeat regularly on excel and would like to automate it.

I will have a file in excel with data which is exactly 6 columns (A to F) but with any number of rows (minimum of 2).
The process would be:

1) Insert new (blank) alternate rows after each row - so line 1 will have data, 2 will be blank, 3 with data, 4 blank etc. - this should be done until the last line with data. The macro I currently use for this step is:

Sub InsertAlternateRow()
Do While Not IsEmpty(ActiveCell)
ActiveCell.EntireRow.Insert
ActiveCell.Offset(2, 0).Select
Loop
End Sub

2) Then merge the blank fields on each blank line after the data for column A to F (so the first 6 cells of each blank row).
3) Apply a border to all sides (and inside) for every cell in column A to F, down to the last merged cell.
4) Revise every cell height to be 0.85cm / 32 pixels.
5) Revise cell widths as follows:

A - 1.59cm / 60 pixels
B - 2.38cm / 90pixels
C - 9.31cm / 352 pixels
D - 6.16cm / 233 pixels
E - 3.18cm / 120 pixels
F - 2.78cm / 105 pixels

I want all of these processes to be made together into one macro so I can do them rapidly.

Skills required:
Data Entry, Data Processing, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 22
in 2 days
Hire nagybatonyi
£ 19
in 2 days
£ 20
in 1 days
£ 20
in 1 days
£ 20
in 1 days
£ 18
in 3 days
£ 15
in 0 days
Hire adityasl
£ 11
in 1 days
£ 20
in 5 days
Hire rengrish
£ 20
in 1 days