VBA Data entry, formatting and matching. Very simple
$10-30 USD
Paid on delivery
Create Excel VBA template where where two input data set is automatically formatted and matched in the Template.
NOTE: I do not want to be installing any additional .OCXs or .DLLs. Should work on excel '07 and onward. Also, dont bid with a "few days" to get it done. Its super simple for any VBA
programmer to do in under an hour, therefore, same day to be done.
1. In "General Template" Column A is "Market Data Time" the data from which comes from Sample_Data#1.
** Need to convert double column data such as "2011.12.27" "0:34" to single colunm in the format "12/27/11 0:34"
2. In "General Template" Column B is "Market Data Price" the data from which comes from Sample_Data#1 file Column F.
3. In "General Template" Columns C, D, E, E come from Sample_Data#2 file and should be formatted and added to General Template as a string containing data of "Short Entry", "Date/time",
"Price".
5. In "General Template" if there are two positions for the same time in Column A, then they should branch out for calculation of data but still be within the same "data/time".
6. Ability to control the data selecetion of input files in the General Template.
7. Source code.
Project ID: #22302878
About the project
Awarded to:
Hello (The currency data GBPJPY is not in either of the sample file??) I am working with XL and VBA for more than 10 years and also have good understanding of FX market. I can do this work. Regards. Reuben
27 freelancers are bidding on average $31 for this job
"Hi, I am good in your required project; I also have a great working experience of more than 10 years. To ensure please visit my profile and check customers satisfaction level. I will complete your project within you More
Hello! I can create the VBA script in 1 day maximum. I can start now. You will not be dissapointed, I have a big 31% rehire rate. Thank you!
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
I can have this done for you, without any issues, thank you. ....................................................
$ 17 Only ------ In just 3 Hours ------ Excel Data Management, VBA Macro Coding, Formula Generation and Automation Expert
Hi. Simple project. I can write this project in 1 day. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps More
Proper skills. Lot of Experience in similar positions. You will be satisfied with what you see . 10 years working with data Macros, vba and queries. Let me know for more.
Hi, am an EXCEL VBA expert. I can address your requirement. We may discuss over chat for specific requirements
Hi, I am Sumit Choudhary. I saw your requirement for an excel vba expert. I have done many projects in excel. Can send you sample if needed. I have an MBA and have extensive experience in tutoring students in Economi More
Hi there. Luckily, i have done projects involving reading and writing of CSV files to Excel sheets using dropdown selectors of file utilizing userform.
I can help you do the project very fast & accurate. I've extensive experience team ready to start work when you ping me. I'll see the details of project its easy work for me. I'll do the work will be absolutely perfect More
I have extensive experience in evaluating business & field situations, analyzing market reports, presenting reports to the management, which help them in taking right decisions and grow business.
Hello! I have 5 years of experience in Data Entry and copy typing. I also have experience in working with clients! I am very reliable, hardworking and precise and you will not regret choosing me. You can contact me, More
Hi, I already read all of your project description and requirement in details. I'am an expert in data entry and typing in the Microsoft Word and Excel, I will give my best and efficient work for your project. Lookin More
hey, i am ready to writ your data and start right now i am good and fast writer and i have good experience on using microsoft office for more than 5 years i am very good at using word and excel please send me to dis More
Hi My self santosh. I am a data entry operator . I am very sincerely complete your work . I have one year experience in call center idea cellular limited (Aditya Birla Minacs) . please Once give me Your work and More
Hello Employer ! I have been working on Excel/VBA for more than a decade and have done multiple such automations. Thanks, Mukesh L.
