Write robust Excel formulae to organise rows of data and write macro

$30-250 AUD

Opravljeno

Objavljeno

pred skoraj 5 leti

$30-250 AUD

Plačilo ob dostavi

I have a simple list of Milstones that I need organised as per my example on the second tab of the worksheet, but with better formula. I have used 25 IF statements in one formula which is clearly not correct. All it is doing is getting the months from the first sheet and then grouping all of the tasks and exact finish dates into single cells next to the months. I need the formulas rewritten so that they do this AND account for all of the tasks on the first sheet. I also need a macro written that runs when the document is saved to copy everything from the 'Milestone Data - Formulae' tab into a the third sheet, but only copy and paste the values, not formula. I have another piece of software that reads from this sheet and it can't read cells with formulae in it. The budget for this project is USD50.

Excel

Visual Basic

ID projekta: 20040518

Več o projektu

14 ponudb

Projekt na daljavo

Aktivno pred 5 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@Taisho

Hello, instead of formulas, I would remove duplicate worksheet and produce output only in Milestone Data - Formulae with VBA macros (naturally it would be renamed). There is no need to export anything before save - output will be pure values, updated automatically on worksheet activation. Thanks to this it will be synced all the time with source data, without any manual activity. Best Regards

$40 AUD v 1 dnevu

5,0

(54 ocen)

4,9

14 freelancerjev je oddalo ponudbo s povprečno vrednostjo $63 AUD za to delo

@Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi

$155 AUD v 3 dneh

4,9

(101 ocen)

6,2

@shikhamehta

Hey, I saw the workbook and you do not need this to happen in two steps. I can create a macro that will create the final sheet on click of a button and it will not have any formulas so your other software will be able to read it. Does that sound good? Please accept my bid and I will get going on the project right away. Best Regards, Rishi

$65 AUD v 1 dnevu

4,8

(98 ocen)

6,4

@best4best

I can replace existing nested IF formulas using Array formulas. Regards Mamta

$30 AUD v 1 dnevu

5,0

(132 ocen)

6,3

@nvchien94

Hello there, I am an Excel expert with over 300+ projects in macro/VBA. I can create macro to do all the task in this file for you. You do not need formula anymore. This will make every thing clean and fast process. Please contact and we can start right now. Thanks.

$30 AUD v 1 dnevu

5,0

(93 ocen)

5,4

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$150 AUD v 3 dneh

4,8

(63 ocen)

5,6

@daniyal3214

I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform data analysis, financial analysis, financial modeling and automation. I will be happy to discuss in detail how I am highly suitable for this project.

$70 AUD v 1 dnevu

4,7

(48 ocen)

5,4

@writingapp

Hi. Simple project. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$50 AUD v 2 dneh

5,0

(5 ocen)

2,2

@topacademictutor

Hi! I have 10 years of Experience in the Writing Industry and can provide you “PREMIUM QUALITY WORK” within your “GIVEN DEADLINE” with “PERFECT GRAMMAR” and “ZERO PLAGIARISM”. I have 500+ "EXCELLENT REVIEWS" which are a guarantee for my best Quality. Please see my profile and portfolio for sample work. Open chat and send me a message so we can finalize this deal as per your budget. Looking Forward… (Top Quality Experts).

$30 AUD v 1 dnevu

5,0

(3 ocen)

1,9

@rashedkhanrubel

Hi, I have read the project description & want to make logical formula & macro for this project. Please send a massage so that i can start the work. Thanks.

$30 AUD v 7 dneh

5,0

(3 ocen)

1,9

@TopWritingGuru

Hi! Since functioning from 2008, I have accomplished hawk eye for the requirements, and I have all the aptitudes to produce showpiece as per your anticipations. Creating a masterpiece is an art, and I am a master in it. For further discussions, please message me in private messenger so we may finalize the deal. Looking Forward; Top Writing Guru n

$30 AUD v 1 dnevu

5,0

(1 ocena)

1,2

@PremiumSolution

Hi I assure you quality work as per the mentioned deadline. I can provide you with a guarantee of 0% plagiarism and can provide your work as per requirements along with free of cost changes facility. https://www.freelancer.com/u/PremiumSolution?w=f. Thanks!

$30 AUD v 1 dnevu

5,0

(1 ocena)

0,6

@AnowarRatul

$ 30 ONLY !!!!! Sir, I have seen your attachment and understand your requirements very well, it is quite basic to me. I have expertise in Excel, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short time and for VERY CHEAP rate. Please CONTACT me before closing the project, I will send you a draft project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar

$30 AUD v 1 dnevu

5,0

(2 ocen)

0,6

@PageOllice

Hello Dear, I have expertise in PHP, Laravel, WordPress and HTML. I have 11+years experience in mobile and web development. I am interested in your project and invite you to discuss in details. Please reply so that I can show you my past result. Looking forward to hear from you. Thanks, Page O.

$140 AUD v 7 dneh