Excel Data Sort with VBA / formula sort

Dokončeno Zveřejněno May 20, 2014 K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

I require up to 10 spreadsheets to have 4 date columns reconciled into an added column which shows the latest date in the series +5 years. Attached is an example of the columns highlighted in Red with the New column required highlighted in green with examples of what should be created.

12 separate yet same formated excel sheets which may have between 7000-10,000 records will need the solution provided.

If you think you can help provide a solution please enquire!

We require a fairly quick turnaround of around 3-5 days after sourcing a capable freelancer.

Cheers

Excel Visual Basic

Identifikační číslo projektu: #5969379

O projektu

43 nabídek Projekt na dálku Aktivní May 22, 2014

Uděleno uživateli:

aarifakhtar

Hi: Please try this formula in Column W: =DATE(YEAR(MAX(S3:V3))+5,MONTH(MAX(S3:V3)),DAY(MAX(S3:V3))) Please let me know if it works

$250 AUD za 0 dní
(156 recenzí)
6.9

43 Freelnceři na tento projekt zveřejňují nabídky v průměru $277

jaylancer43

Hello Sir - Editing my bid since its much simpler now. I will provide you with a working version of file before you award me the project. Thanks, Jay

$250 AUD za 0 dní
(602 Recenzí)
8.3
Teloquence

Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere Další

$250 AUD za 0 dní
(334 Recenzí)
7.7
seaanddream

Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 Další

$250 AUD za 3 dní
(258 Recenzí)
7.6
zExcel

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$250 AUD za 1 den
(254 Recenzí)
7.6
deepbluetech

A proposal has not yet been provided

$400 AUD za 3 dní
(197 Recenzí)
7.3
maverick44000

Hi Mate. I have looked at the sheet and there is some inconsistency in the example. The second green highlighted entry should be 13/12/2019 and not 13/12/2018. If this is correct, I am ready to take up the task and get Další

$300 AUD za 1 den
(86 Recenzí)
7.0
hdlong66

Dear Sir/Madam.I'm highly interested in your project, but I can't catch your requirement. Let's discuss about more details. Best regards,

$250 AUD za 5 dní
(123 Recenzí)
6.7
priyal1997

Dear Sir/Madam. As top rated excel expert in this site, I'm happy to help you on this task. I went trough your attachment and I assure you that I will do this with 100% accuracy. (I can automate the process where you Další

$250 AUD za 1 den
(179 Recenzí)
6.7
greggfletcher

Hello, i have expertise in VBA and Excel. The project will be completed within 2 days. If you are interested in my bid, please contact me. Thank You. Best Regards.

$421 AUD za 2 dní
(45 Recenzí)
6.6
svet63

VBA developer since 1997. THIS IS CERTAINLY DOABLE. I give it 3 days because of the time difference we have. Otherwise, 2 days would be enough. Cheers.

$366 AUD za 3 dní
(80 Recenzí)
6.7
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Další

$250 AUD za 0 dní
(163 Recenzí)
6.4
danielgpratidya

Hi, I think you've made a mistake in row 5: it should be 13/12/2019 (5 years from 13/12/2014). Anyway, I got the idea. I'll write a vba codes script to automate the process. If you wanted me to run the macro prog Další

$250 AUD za 3 dní
(196 Recenzí)
6.5
chriskerpini

Hello, It can be done with a VBA module, implemented as an Excel add-on, so that to easily be selected from any of the spreadsheets you want to apply it. No questions, everything is clear. In fact, I can finish that Další

$250 AUD za 1 den
(73 Recenzí)
6.5
gokulanand

Hello, I can assure you to complete this task in the next 24 hours. However, I couldnt see any highlighted columns in the attached spread sheet. Can we discuss more on this ? Let me know if you are interested. Th Další

$250 AUD za 1 den
(98 Recenzí)
6.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Další

$250 AUD za 5 dní
(120 Recenzí)
6.3
gangabass

Hi, I'm VBA expert with 10+ years of experience that's why I'm sure you'll be impressed with my work. I can create VBA macro for you in less than two days and I can offer you best price here. Thanks. Roman

$250 AUD za 2 dní
(106 Recenzí)
5.9
nagybatonyi

I think you overestimated the workload of this job, I can give you a much lower bid, between $100-150, if you repost the project with lower budget limits. In my approach you'll have opportunity to consult details with Další

$250 AUD za 1 den
(62 Recenzí)
5.7
jayjossef132

I can start working this project. Let me handle this project. I can accurately sort all information needed. Proven skills and experience similar to my previous work. I am looking forward for your response to get starte Další

$300 AUD za 3 dní
(66 Recenzí)
5.5
BDtW

Hello and thank you for posting this nice project here. Very recently I have completed several jobs here in freelancer and other sites where I had to write up complex Macros that manipulated data in various ways. Th Další

$250 AUD za 2 dní
(33 Recenzí)
5.2
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features li Další

$250 AUD za 5 dní
(66 Recenzí)
5.5