Closed

I would like to hire an Excel Expert - 17/02/2017 08:35 EST

I want to create a live list of all incomplete from my current excel file. Each week is a new tab such as Week of Feb 6, Week of Feb 13, Week of Feb 20 and so on. Each of these tab has a running list of task that will be marked as open or close. The goal is to have all the task that are marked as open appear in a separate named "Open Items".

How could I program my excel sheet to create live list of all the items marked as "Open". I have tried using and if statement, but I can't figure out how to move the entire row to the "Open Items" tab. Thank You

Skills: Excel

See more: how to hire an expert with excel spreadsheets, how do i find an expert in excel development, how can i expert in excel, hire someone who is an expert in excel, excel expert services for hire, expert numbers excel, expert macro excel, expert microsoft excel india pakistan, excel hire, expert quarkxpress excel, expert knowledge excel, expert financial excel, data analysis excel hire, excel vba starting external program, expert vba excel, making excel file stand alone program, excel file stand alone program, pricing custom excel vba inventory control program, excel helphow can sum cells sheet, can excel project stand alone program, convert excel workbook stand alone program, simple excel vba open external program, est excel templates

About the Employer:
( 0 reviews ) United States

Project ID: #13138029

33 freelancers are bidding on average $29 for this job

cgullapalli

Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with f More

$30 USD in 0 days
(357 Reviews)
7.2
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$50 USD in 1 day
(109 Reviews)
6.2
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. Your job requires a small macro. The best way to launch it More

$20 USD in 0 days
(59 Reviews)
5.7
sandroshubladze

Hello! I am an Excel expert and VBA programmer. I am fast, accurate and efficient. I work with a team which is quicker and more precise. I would like to work for you on this project. If interested, please contact me. More

$35 USD in 1 day
(41 Reviews)
5.4
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$45 USD in 3 days
(59 Reviews)
5.5
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients.

$25 USD in 1 day
(16 Reviews)
5.0
nwss1986

hi.i can start right now and can deliver to you in a couple of [login to view URL] you send me the file? thanks!!

$25 USD in 0 days
(25 Reviews)
3.9
sithalchordia

Hello I have prior experience in excel macros and I can do this job for you. Can you please provide me a sample excel that you are referring to and for which you want the open items to be moved into a separate sheet. More

$30 USD in 3 days
(7 Reviews)
3.7
CoDeep

Hi Sir, The task mentioned by you looks quite simple and is achievable by writing a macro. The macro would basically navigate through all the sheets present in the excel file and insert the data in your sheet called More

$30 USD in 1 day
(3 Reviews)
2.2
$25 USD in 1 day
(2 Reviews)
2.2
wasifmustafa

hi. I have created a quick macro to create open items in the new tab. Kindly review the attached link for review. [login to view URL]

$20 USD in 1 day
(3 Reviews)
2.3
$25 USD in 1 day
(1 Review)
1.9
rafeemd

I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.

$28 USD in 1 day
(1 Review)
0.8
rajibspi7

I know what do you want and i have more skill about your project. So contact with me about your project done in time with your budget.

$35 USD in 1 day
(1 Review)
0.5
HaykDag

Hello, I can do what you want buy Macro and can send you in three hours, if you want me to do give me this job.

$35 USD in 1 day
(1 Review)
0.5
idorat88

Hello, I'm an excel expert, doing a day-to-day full time job as performance analyst in a hi-tech company. I'd be happy to develop the spreadsheet tool you're looking for using my vast experience and skills. Looking f More

$22 USD in 5 days
(0 Reviews)
0.0
ariful01935

Dear Hiring Manager, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel More

$25 USD in 1 day
(0 Reviews)
0.0
$15 USD in 2 days
(0 Reviews)
0.0
gurjinder1985

Hello sir/madam I AM DOING WEB SCRAPING, INTERNET RESEARCH, DATA ENTRY JOBS ON WORD AND EXCEL FROM LAST 10 YEARS. I AM VERY GOOD IN DATA ENTRY WORKS. I AM A POST GRADUATE AND I HAVE WORKED AS CLERK IN VAR More

$25 USD in 1 day
(1 Review)
0.0
Agstills

Hey there, I have made the solution you need and its working perfectly. It will work even if sheets are added or deleted as long as all new sheets have same headers. my solution will copy all open items to a sheet call More

$55 USD in 0 days
(0 Reviews)
0.0