In Progress

i need an excel expert

i have 2 sheet

project sheet : projects which include A column = project names and B column = task status

task sheet: A column = task name, B column = project name, C column = task status( True, False)

i used this formula ( if the project Sheet A column = tasks Sheet B column then copy the tasks sheet Column C and paste it in project sheet B column.

=VLOOKUP(A2,Sheet2!$B$2:$C$100,2,0)

i need when i add any more task in tasks sheet and connected to a project and the task status false it have to copy it to the same cell in project sheet as false even if i have 3 task for the same project is true and the 4th is false it have to show false in project sheet

example

Tasks Sheet A1= fix water pump, B1 = Water Project, C1= True

Tasks Sheet A2= cut water, B2 = Water Project, C2= True

Tasks Sheet A3= buy new pump, B3 = Water Project, C3= False

Then Project Sheet in task status for the Water Project should be False because on of the task is false but if they all was true then the task status should be true

2nd: i need in the tasks sheet C column(task status) to be changed between true and false according to the D Column (task date) if the task date <= today date then C column should be false by default if the task date > today date then task status should be True

Skills: Excel, Data Processing, Data Entry, Visual Basic

See more: need excel expert, need excel vba expert, need excel formula expert, excel expert need simple solution, need excel expert match columns, need excel expert create macro, i need a good excel expert in singapore, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i need excel expert, need a excel expert, need an excel expert to organize some data for me i need t, need an excel expert, need ms excel expert in nagpur, need computer expert to setup my excel worksheet in mililani hawaii, any company need excel expert from home, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, need excel expert on hire, gmetrix excel expert 2016 practice exam 3

About the Employer:
( 1 review ) Riyadh, Saudi Arabia

Project ID: #23550630

26 freelancers are bidding on average $33 for this job

engrranakaleem21

Hi, I have understand the project requirement and interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more and start the project. Than More

$10 USD in 1 day
(42 Reviews)
4.9
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

$30 USD in 3 days
(18 Reviews)
4.5
merinsinha

Hi i can start right now. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best qualit More

$10 USD in 1 day
(15 Reviews)
3.6
lotusvijay

Hi Good Day, I can do this immediate after you accept my bid i am expert in Excel Automation, Data Entry,Internet Research and RPA(Robotic Process Automation).kindly give me this opportunity thank you.

$15 USD in 1 day
(21 Reviews)
3.4
graj22

This can be completed using arrays. I can complete this for you .Let us discuss more over a chat and proceed accordingly

$25 USD in 1 day
(1 Review)
0.6
mehedi1118

Hello Sir, I read your project carefully .You are searching for Data entry Expert. This is Mehedi Hasan. I am professional Data entry Expert & Digital Marketer. I have huge Experience in this sector. Let’s discuss more

$10 USD in 5 days
(0 Reviews)
0.0
Rafisdream

I want to work

$25 USD in 1 day
(0 Reviews)
0.0
ramsagar298

Hello Relevant Skills and Experience Excel, word etc

$20 USD in 1 day
(0 Reviews)
0.0
natheemmaster

I have lots of pertinent experience, have a really strong work ethic & have great communication skills

$30 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
Sonioa4398

Hello sir i understand your needs. i have long experienced for excel data entry work. my searvices Word & Excel Online Data Entry Offline Data Entry Web research E-commerce product listing Copy paste job Primary Dat More

$10 USD in 6 days
(0 Reviews)
0.0
$395 USD in 33 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
Kinjal2212

Hire me for excel project work. I will complete work in time limit. Relevant Skills and Experience I am computer Enginer. Fresher for this work.

$25 USD in 1 day
(0 Reviews)
0.0
fahadhaq97

Hey, Thanks for checking my proposal. please send me a message to discuss about your project

$15 USD in 1 day
(0 Reviews)
0.0
Parthiban09

Hello User hope you are doing great!!! I have experience in working with McKinsey Consultants for their corporate presentations. If you are looking for someone who can work fast, then I might be you best pick!!! Lookin More

$15 USD in 1 day
(0 Reviews)
0.0
kraftsndesigns

Hello I am having an experience in data entry , word , excel , and copy writing. i wish to do this job and want to complete before the lead time. The work will be as per requirement and i will give you unlimited corr More

$25 USD in 3 days
(0 Reviews)
0.0
Chanjalk

We are a freelancer company and We have a Dedicated staff to do the data entry operation and ? voice support and we will share the address with you

$15 USD in 10 days
(0 Reviews)
0.0
faizansuper1

I have gone through the project requirement and interested to work for this project. I want to do it. Please send a message so we can discuss more and start the project. Thanks.

$12 USD in 2 days
(0 Reviews)
0.0