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",
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.
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 I am experienced in Microsoft office tools. I can work daily 2 hours in weekdays and 6 hours on weekends. Will deliver results accurately.