Em Andamento

Simple Excel macro. Open txt files, import data, etc

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

Habilidades: PHP

Ver mais: want excel spread sheet, make spread sheet, open text, visual basic form excel, vb excel, transpose, simple macro, simple excel, import two, excel spread sheet, sample data input, excel transpose source code, open input file php, excel contains, php open input file, open input file, excel macro txt, sample visual basic excel, range macro excel, import data macro excel, sheet excel visual basic, excel macro program, txt file import excel, import excel data form, php macro

Acerca do Empregador:
( 1 comentário ) Australia

ID do Projeto: #3031186

Premiar a:

prasanna123

See private message.

$20 USD em 14 dias
(58 Avaliações)
5.1

6 freelancers estão ofertando em média $16 para este trabalho

icodeinvb

See private message.

$17 USD in 14 dias
(316 Comentários)
7.1
TakeRealUK

See private message.

$17 USD in 14 dias
(552 Comentários)
6.7
PHPTechProvider

See private message.

$12.75 USD in 14 dias
(84 Comentários)
5.1
vprovw

See private message.

$12.75 USD in 14 dias
(6 Comentários)
3.2
bigursusvw

See private message.

$17 USD in 14 dias
(12 Comentários)
2.9
jvmvw

See private message.

$17 USD in 14 dias
(3 Comentários)
1.3