Simple Excel macro. Open txt files, import data, etc
$15-20 USD
완료함
게시됨 20년 이상 전
$15-20 USD
제출할때 지불됩니다
I need a program (VB macro) does the following. 1. Opens a window so I can select certain text files. 2. Once I select the text file, I get asked two questions. 2a. (1) Is this text file a "x" or "y" 2b. (2) Is this text file a 1,2,3,4 or 5 3. Copy the text file to an "input" worksheet in Excel. *the text file contains a lot of data, only 2 rows of it are of interest. 4. Multiply these two rows together (A1xB1, A2xB2, etc) and transpose the resulting data to a column. 5. This column of data will then be copied into a certain worksheet (1,2,3,4 or 5) into a certain range (x or y). Which is what you specified in the questions 2a and 2b. Basically I want something more automated. At the moment I am, opening the text file, select all, copy, go to the "input" worksheet, paste, operate a little macro to multiply the two rows together and transpose them into a column, copy this column, click on worksheet 1,2,3,4 or 5, paste the column into cell "x" or "y" If you successfully bid, I'll send you the Excel spread sheet, some sample text files and explain what all the 1's, 2's, x's and y's stand for. So it will make a lot more sense than I have explained here. :}
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
## Platform
Win 95, Office 97