Excel Data Sort with VBA / formula sort
$250-750 AUD
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
Identifikační číslo projektu: #5969379
O projektu
Uděleno uživateli:
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
43 Freelnceři na tento projekt zveřejňují nabídky v průměru $277
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
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ší
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ší
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
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ší
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,
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ší
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.
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.
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ší
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ší
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ší
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ší
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
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ší
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ší
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ší