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
and after appylin the script/macro/vb etc then i should get the following results
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.