Closed

Microsoft Office Macro

We need a simple Excel/Office macro that will take columns of text and export them as numbered lists. So, for example, let’s say we have an Excel spreadsheet and it has 50 columns and 46 have numbers and 4 have text and we want to export the four text based columns in the manner described above.

Column B

Please describe your favorite kitchen instruments?

I have a Gelco microwave oven, a breadmaker and several devices for automated cutting and food processing. Of course I also have a full set of kitchen knives and other such utensils. I have many different kinds of kitchen contraptions, including an ice cream maker, a rice cooker, a convection and microwave oven.

I have a walk in freezer since I run a commercial catering business from my home. I also have a blender. I don’t have much just a simple oven and a refrigerator.

How it should appear in Microsoft Word

1) I have a Gelco microwave oven, a breadmaker and several devices for automated cutting and food processing. Of course I also have a full set of kitchen knives and other such utensils.

2) I have many different kinds of kitchen contraptions, including an ice cream maker, a rice cooker, a convection and microwave oven. I have a walk in freezer since I run a commercial catering business from my home. I also have a blender.

3) I don’t have much just a simple oven and a refrigerator.

In addition we want a feature whereby an identifying code or description is taken from another column and placed next to the text but separated from it in brackets, such as below:

1) I have a Gelco microwave oven, a breadmaker and several devices for automated cutting and food processing. Of course I also have a full set of kitchen knives and other such utensils. (State University Student)

2) I have many different kinds of kitchen contraptions, including an ice cream maker, a rice cooker, a convection and microwave oven. I have a walk in freezer since I run a commercial catering business from my home. I also have a blender. (Private University Student)

3) I don’t have much just a simple oven and a refrigerator. (Non Student)

These phrases will be stored in another column but on the same row as the text to which it is attached. The macro should either have a control panel where one can specify on which columns to perform the operation, and the operation should be performed on multiple columns at the same time. OR, it could be done by highlighting the needed columns. The macro should work in different versions of Office especially 2003 and later editions.

Skills: Microsoft

See more: work home microsoft, work microsoft home, word processing work home, word maker, run business home, office work home, microsoft excel spreadsheet, run office, export business home, microsoft macro, microsoft business, microsoft work, macro microsoft word, favorite lists, simple macro, rice, microwave, microsoft office word, kitchen set, HOME OFFICE, food catering, excel microsoft word, blender, excel spreadsheet feature, excel macro row

About the Employer:
( 73 reviews ) New York, United States

Project ID: #4077208

10 freelancers are bidding on average $95 for this job

deepbluetech

I am an Excel macro expert and can take on the job. Let me know.

$100 USD in 3 days
(19 Reviews)
4.1
weonlydo

No problem. A very straightforward macro. Please check PM for references.

$75 USD in 1 day
(2 Reviews)
3.6
emova

Hi. I understand your requirement perfectly and can assure you of an excellent job. Regards. Emmanuel.

$75 USD in 5 days
(5 Reviews)
3.2
jaylancer43

Greetings..!! Please check your PM...!!

$35 USD in 1 day
(1 Review)
1.2
vickkey7

I am ready for this project. thanks

$180 USD in 2 days
(0 Reviews)
0.0
Foyzurrahman

Hi, i will complete your project successfully.

$110 USD in 3 days
(0 Reviews)
0.0
onlineupdatebd

Hi, I have worked in similar projects and delivered successfully. Kindly grant me this effort. Thanks & Regards, Onlineupdatebd

$100 USD in 2 days
(0 Reviews)
0.0
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

$45 USD in 2 days
(1 Review)
0.0
Prashantsd

Anything is possible. This can be done.

$75 USD in 3 days
(0 Reviews)
0.0
Denisrq

I'll do this job on time and according to your specifications.

$150 USD in 5 days
(0 Reviews)
0.0