Simple Macro Programme for excel

Closed

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)

[url removed, login to view]

[url removed, login to view](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 [url removed, login to view] / 32 pixels.

5) Revise cell widths as follows:

A - [url removed, login to view] / 60 pixels

B - [url removed, login to view] / 90pixels

C - [url removed, login to view] / 352 pixels

D - [url removed, login to view] / 233 pixels

E - [url removed, login to view] / 120 pixels

F - [url removed, login to view] / 105 pixels

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

Skills: Data Entry, Data Processing, Excel

See more: macro programme excel, macro programme, sub insertalternaterow, data entry macro, 233, simple macro, programme, macro e, excel automate, insert macro excel, excel row column, excel macro row, blank fields, macro merge rows, entry processes, excel column row, excel 2013 macro, excel macro merge rows, column row excel, automate data entry, macro data entry, excel macro simple, macro mail merge excel, excel macro mail merge access, merge excel macro

Project ID: #4921780

Awarded to:

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

£22 GBP in 2 days
(63 Reviews)
5.9

51 freelancers are bidding on average £16 for this job

nagybatonyi

Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

£19 GBP in 2 days
(48 Reviews)
5.6
seaanddream

Hi, your 5-star excel expert is ready to help you...regards,

£20 GBP in 1 day
(43 Reviews)
5.4
vbexcel

Experienced Excel/VBA coder pro, I can get your assignment completed ASAP

£20 GBP in 1 day
(26 Reviews)
5.4
deepbluetech

I can take on the job. Let me know.

£20 GBP in 1 day
(79 Reviews)
5.4
MDavidCrompton

Hi, This will be no problem at all because, by a strange coincidence, I did exactly the same thing for a client in Sri Lanka yesterday. Please see PM

£18 GBP in 3 days
(25 Reviews)
5.1
priyal1997

Hi I,m happy to help you on this.. Thanks - Priyal

£15 GBP in 0 days
(53 Reviews)
5.1
adityasl

Please see PM.

£11 GBP in 1 day
(84 Reviews)
4.8
Kryptora

Hello, I am a .NET, VBA and VSTO software developer. I have nine years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfaction.

£20 GBP in 5 days
(22 Reviews)
4.7
rengrish

Macro Expert Freelancer. Please check my reviews and ratings.

£20 GBP in 1 day
(39 Reviews)
4.6
maverick44000

Hi Leisurewear. Being highly proficient in Excel, I shall be able to deliver you the control sheet in a few hours. Lets begin and finish the job. Regards

£24 GBP in 1 day
(10 Reviews)
4.6
DrTech76

Not a problem at all. Can do whenever you're ready. Kind Regards

£15 GBP in 0 days
(26 Reviews)
4.6
microk

Expert Here.. Please check PM..

£16 GBP in 1 day
(21 Reviews)
4.3
expertatwork

Hey Leisurewear, Get this done by us in less than an hour. Please reply with the excel sheet that you are using now. thanks !

£10 GBP in 1 day
(32 Reviews)
4.0
buyaspreadsheet

Why pick me? Simply because it is done. See PM. Best regards, Andrew

£15 GBP in 1 day
(10 Reviews)
4.0
sswijaya

Hi, let me help you with this.

£20 GBP in 1 day
(12 Reviews)
3.8
jaylancer43

Greetings !! Please check your PM for details. Thanks.

£18 GBP in 3 days
(15 Reviews)
3.7
Edison1983

Good Day!... ***Get the Macro immediately!...I'm done with your work**** I'm an Excel Automation Expert. Pls check my private msg to you.

£18 GBP in 0 days
(5 Reviews)
3.2
tomislav1975

I'm the VBA expert everybody talks aboute and I can solve this for you. Take your chance on me ;).

£19 GBP in 3 days
(2 Reviews)
2.9
hbxfnzwpf

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience now. Please trust me, and let expert do it.

£17 GBP in 1 day
(2 Reviews)
2.9
drevak

Consider it done...done professionally!

£15 GBP in 0 days
(2 Reviews)
2.9