Käynnissä

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

Taidot: Excel, tietojenkäsittely, tiedonsyöttö, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Riyadh, Saudi Arabia

Projektin tunnus: #23550630

26 freelanceria on tarjonnut keskimäärin 33$ tähän työhön

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 Lisää

$10 USD 1 päivässä
(42 arvostelua)
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 Lisää

$30 USD 3 päivässä
(18 arvostelua)
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 Lisää

$10 USD 1 päivässä
(15 arvostelua)
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 1 päivässä
(21 arvostelua)
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 1 päivässä
(1 arvostelu)
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 5 päivässä
(0 arvostelua)
0.0
Rafisdream

I want to work

$25 USD 1 päivässä
(0 arvostelua)
0.0
ramsagar298

Hello Relevant Skills and Experience Excel, word etc

$20 USD 1 päivässä
(0 arvostelua)
0.0
natheemmaster

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

$30 USD 2 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
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 Lisää

$10 USD 6 päivässä
(0 arvostelua)
0.0
$395 USD 33 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
fahadhaq97

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

$15 USD 1 päivässä
(0 arvostelua)
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 Lisää

$15 USD 1 päivässä
(0 arvostelua)
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 Lisää

$25 USD 3 päivässä
(0 arvostelua)
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 10 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0