Kapalı

Excel If Then Else Macro

Required an Excel Macro that can perform an "If Then Else" function in an Excel spreadsheet.

The Macro needs to read a range of cells & make a choice based on the contents. The results of the decision tree should be delivered to another range of cells. The data needs to be set up in cells within the same sheet or referenced from another sheet.

For instance a range of cells contains names, classes have to be assigned based on those names. For 15 names there would be 15 cells containing the name data. The Macro would then scan the cells defined in another cell containing the range (eg the macro would read cells "E1 : E45" based on defined data in cell G1 for example). The results would be written to another range of cells also defined in a cell (eg the Macro would write the results in cells "F5 : F50" based on data defined in, say, H1). The valid results need to be defined in another range of cells (eg "Fred Smith:Room 2", "Anne Smith:Room 5" etc). There needs to be a back stop so that undefined results can be prevented from leading to an error (eg the "Else" result would be a definable value such as "Unknown") & should also be a value set up in a cell that can be easily defined.

I'll attach an example file in a littel time to show excatly what is needed.

Good luck.

Beceriler: Visual Basic

Daha fazlasını gör: excel else, excel macro else, else macro excel, else excel macro, excel macro range, macro else, macro excel else, else macro, excel macro else cell, else decision tree, macro else excel, else function excel macro, tree range, range tree, excel &, be smith, excel macro else range, excel macro ifthenelse, what is macro in excel, n excel

İşveren Hakkında:
( 4 değerlendirme ) Brier, United States

Proje NO: #36963

Bu iş için 18 freelancer ortalamada $48 teklif veriyor

gaffapi

hi. this sounds like an hour task for me.

$30 USD in 0 gün içinde
(46 Değerlendirme)
6.0
rajanlengde

It is simple, working excel vba from years. Just accept and get it done.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(28 Değerlendirme)
5.2
izwan00

I'm expert in this kind of thing. Please see my review for my past project about excel macro. Please post more details via pm. Regards.

$100 USD in 5 gün içinde
(8 Değerlendirme)
3.8
abhijitcari

I could do this for u.

$50 USD in 10 gün içinde
(5 Değerlendirme)
3.2
rajneeshag

Hello, task seems to be easier. I can do it very fast and easily. Thanks

$30 USD in 2 gün içinde
(1 Yorum)
2.4
aadiit

we are a creative team, who are working in companies. we are interested in taking up your project. we will complete the project with in the agreed time period. we are looking for your positive response. Regards A Daha Fazla

$75 USD in 10 gün içinde
(0 Değerlendirme)
0.0
sanee218

Dear Sir/Madam. Have done Such assignments before also. Assure you the accuracy and quality. Hoping for Mutually beneficial relationship. Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
GlobalSoft

Hi I am New Freelancer thats why have no feedback shown However the tasks seems to be simple and will probably get over in a day Please provide futher clarification on the requirements if interested. Thanks.

$30 USD in 2 gün içinde
(0 Değerlendirme)
0.0
allalliance

Hello, This is a simple project for me because i've done many similar projects for several companies in my hometown. The project can be done in a few hours so please let me know the exact details. Best regards, TK

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Shrike

Hey sounds simple enough... should have this done and tested in an half an hour. All code we undertake includes a life time Garenty and free modifications. Working with us is a smart move to make and we look forw Daha Fazla

$30 USD in 0 gün içinde
(0 Değerlendirme)
0.0
kmohan1962

Hello, It seems deriving the result with macro for your job is ver simple and will take few minutes only. If you'd have posted your file, your job is done. Regards. My rate is only for quoting purposes only it can b Daha Fazla

$30 USD in 0 gün içinde
(0 Değerlendirme)
0.0
ganeshsk

Hi Mike Working with Excel since it is inception in Ma environment in 1984, I moved from Excel macros before VBA and now use VBA and Real basic a better cousin of VB. Your job should present no difficulties, Would Daha Fazla

$50 USD in 2 gün içinde
(0 Değerlendirme)
1.0
mouserx

Hi can do this for you starting right now, wait for your answer, thanks.

$50 USD in 5 gün içinde
(0 Değerlendirme)
0.0
sapsystems

Hi We can finish it in hrs let us start :-) you can see one of our macro work in PMB for refference. Thanks , Alex.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
vcans

Dear Sir/Madam, We are boutique IT solution providing company that provide solutions and services to few USA companies. We a team of dedicated software professionals that provide quality service on time. Assur Daha Fazla

$100 USD in 7 gün içinde
(0 Değerlendirme)
0.0
mkumar

We are interested

$70 USD in 3 gün içinde
(0 Değerlendirme)
0.0
sweethome

Hi, I can do it for you. Check PMB.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
prgmasters

I have processed similar projects before. And I'm good at office macros' prohramming. If you can be kindly to provide your sample, it will be much helpful for the schedule.

$30 USD in 2 gün içinde
(0 Değerlendirme)
0.0