In Progress

EXCEL WORKSHEET AUTOMATION

Hello folks

I need some script/vba/macro to automate some tasks i require to do on all my Excel worksheets.

I am no coder but i will try to express as best so that u know the requirements.

Actually the main task involves replacing text with numbers.

But before replacing the the text , the text has to be seperated i.e used as TEXT to COLUMN DATA function in EXCEL(by comma)

For example when i open WORKSHEET(excel)file, all rows (text) in the column name as "Industry" has to be replaced by numbers...

There are 40 numbers in total more or less, so for example if there a text 'Accounting' in the row having column name'industry'

then it should be replaced by number '1', so then if there a text names 'Aero-Engineerin' in the same column then it should be

replace by another number '2' ...and so on..

Look below example

industry

Accounting

Aero-Engineering

Bio Technology

and after appylin the script/macro/vb etc then i should get the following results

industry

1

2

3

So in each worksheet there are about 6 to 7 columns for which the data has to be replaced...

what i want is i will open the worksheet...and then can open the [url removed, login to view] and apply

to each column and get results ans save it..

I have attached a sample.

I will provide details of replacement what text with what in which columns etc..

I need this fast and i am ready to down payment as soon as u atleast make one small sample script proving

you can do the things i require.

Thanks.

Skills: Excel, Microsoft

See more: appylin, worksheet worksheet automation, worksheet automation, worksheet in accounting, what do u need to know about engineering, technology in accounting, i want to know accounting, accounting names, accounting express, excel worksheet, what is vba in excel, what is vba, what is macro in excel, vb in excel, microsoft vba, microsoft macro, microsoft excel VBA, Data e try, vba excel, vba excel macro, vba e, vb excel, script automation, save to excel, microsoft automation

About the Employer:
( 13 reviews ) brooklyn, United States

Project ID: #1154408

Awarded to:

valleysoftware

Let's do it. US Provider.

$45 USD in 0 days
(8 Reviews)
3.9

10 freelancers are bidding on average $43 for this job

bharanisrihari

Hello, Excel VBA expert here. Let's start. Please check PM for details. Thanks!

$50 USD in 1 day
(67 Reviews)
6.4
ZeusMan

Looking forward to working with you...

$30 USD in 0 days
(72 Reviews)
5.9
vserv

Hi, I have your demo ready. Pls see your messages. Thanks

$50 USD in 2 days
(65 Reviews)
5.8
simonchen

check p.m.b

$50 USD in 1 day
(2 Reviews)
3.9
surajddk

Hi, Let's Start! Check PMB!!

$50 USD in 2 days
(1 Review)
1.8
kanadyanako

for your consideration.

$30 USD in 1 day
(1 Review)
1.8
sumonmomo

please see the PM

$30 USD in 3 days
(0 Reviews)
0.0
chabby2587

DEAR SIR, I HAVE A GOOD KNOWLEDGE IN MICROSOFT EXCEL...I WILL BE ABLE TO COMPLETE YOUR PROJECT IN NO TIME.. THANK YOU..

$42 USD in 2 days
(0 Reviews)
0.0
ami90s

Hi. I can do it. Please check PM!

$30 USD in 3 days
(0 Reviews)
0.0
erry

i'm good in excel, let's do this job

$50 USD in 1 day
(0 Reviews)
0.0