VBA Data entry, formatting and matching. If you dont understand information provided, please dont bid.
Bütçe $10-30 USD
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.
Seçilen:
dear sir i have read and understand your requirement, i can start and complete this today. please award me. thank you
Bu iş için 5 freelancer ortalamada $21 teklif veriyor
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Daha Fazla
Hi, I have read your proposal and it fits my profile. I speak perfect English, I have extensive experience in administrative work (data entry, data processing, etc.), I handle the office package perfectly and I have ex Daha Fazla
Hi I am experienced in Microsoft office tools. I can work daily 2 hours in weekdays and 6 hours on weekends. Will deliver results accurately.
Hi, i am syafiqa from Malaysia. I already read and understand the requirement that you need. I am very confident to do this job. I have experience on data processing, data entry and excel very well. For your inform Daha Fazla
