Find Jobs
Hire Freelancers

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

$10-30 USD

Closed
Posted about 7 years ago

$10-30 USD

Paid on delivery
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
Project ID: 13174942

About the project

34 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $23 USD for this job
User Avatar
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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$30 USD in 1 day
4.9 (459 reviews)
8.3
8.3
User Avatar
Very easy task for me.. Immediate response and ZERO ERROR GUARANTEED!! Please read my 160+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$15 USD in 0 day
4.9 (312 reviews)
7.8
7.8
User Avatar
Hi, I can write a macro to meet your requirements. With the Macro, all the open actions in individual tabs would get automatically populated in "Open Items tab. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last few MONTHS , I have spent at least 225 HOURS on automation in Excel every month. I can help with your project requirement and send you the macro today itself. Have a Great Day! Srinivasan
$15 USD in 0 day
5.0 (219 reviews)
7.0
7.0
User Avatar
I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients.
$25 USD in 1 day
5.0 (44 reviews)
6.5
6.5
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$15 USD in 0 day
5.0 (255 reviews)
6.6
6.6
User Avatar
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html
$35 USD in 1 day
4.9 (52 reviews)
6.3
6.3
User Avatar
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. It easy task for me because I have done many task like this one. I will use outer loop for Sheets and inner loop from row 1 to last used row to access every row. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets and Creating Consolidated Report. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$30 USD in 1 day
4.8 (100 reviews)
5.8
5.8
User Avatar
Hello, Please share the Excel file. I can write a short Excel file that will search all worksheets and copy the "Open" items to "Open Items" worksheet. You will need to run this macro when you want to refresh the list. It is what you want? Isn't it? Regards,
$15 USD in 1 day
5.0 (25 reviews)
4.7
4.7
User Avatar
I am working as design engineer and My work is to prepare design calculation in excel.I am good in excel
$15 USD in 1 day
4.9 (11 reviews)
4.6
4.6
User Avatar
Hi I am here to assist u inthis project I am an acca member currently wor in finance dept of Qatar Airways Have great skill and exp in excel can assist u with high regards Plz share more info to proceed Thanks Looking forward for this projext positively
$25 USD in 0 day
5.0 (23 reviews)
4.2
4.2
User Avatar
you can send me file I will try to help you.
$30 USD in 1 day
5.0 (5 reviews)
2.7
2.7
User Avatar
Evidently you need a macro to do the job This box has limited space and no provision for attachments. I am Mechanical Engineer, proficient in MS Access, Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$50 USD in 2 days
3.9 (9 reviews)
3.5
3.5
User Avatar
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.
$27 USD in 1 day
5.0 (2 reviews)
1.7
1.7
User Avatar
Hi, I am Prasad,interested to take up the your work. I will not take any advanced mile stones. I will do the work and send you with some restrictions,(ex: like a trial version which can be used only for a limited period).If you are happy with it make the payment and I will send the final product. If you are interested please share the details. Thanks and regards, Prasad.M
$10 USD in 2 days
4.7 (2 reviews)
0.9
0.9
User Avatar
Hey i can do this work for you.. i can move the entire row to open tab page by defining names ranges , and reference functions i have already done the data calling same like this ... you can trust me
$27 USD in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
A proposal has not yet been provided
$24 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 10 years experience in data entry using excel. I am confident of completing the project with efficiency and accuracy.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings ! My name is Flordelyn L. Castañares, 31 years old, and a mother of 3 kids. One interesting fact about myself is, when someone give me a tasks I always make sure that the output is not just great, it should be excellent. I can say that I am very familiar for this kind of work because I have been an Administrative Assistant for 10 years now. Special skills that I possess is that I am highly motivated self-starter who takes initiative with minimal supervision, Enthusiastic, knowledge-hungry learner, eager to meet challenges and quickly assimilate new concepts. I am confident that i can do the job well if given an opportunity to work with. I have been in a related job for ten years. I am good at data entry using Excel,Word, Publisher and Powertpoint, desktop publishing, web research, good communication, typing and writing, computer literate, organizing, email management and with background in Adobe Audition and Adobe Photoshop. I am a highly motivated person who takes initiative with minimal supervision.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I already have this kind of code. Need some modification on that.
$23 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Saudi Arabia
0.0
0
Member since Nov 10, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.