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.
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
30 pekerja bebas membida secara purata $30 untuk pekerjaan ini
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
Hi there. Luckily, i have done projects involving reading and writing of CSV files to Excel sheets using dropdown selectors of file utilizing userform.
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.
I am fresher in the field,so kindly you give me this [login to view URL] you Relevant Skills and Experience I am passed out in [login to view URL],I am fresher.