Em Andamento

Revise Excel Spreadsheet with VBA Macros - Visual Basic

Hello!

I am looking for someone revise an Excel spreadsheet that has VBA macros.

The sheet uses a macro to select a txt file then it reads the txt file and pastes some of the data into excel (columns K & L). This is on the "Current" tab of the attached .xls file.

Ideally, I would like to select two different txt files and compare the data in adjacent columns. An example of what I was thinking is in tab "Ideal"

As you will see, columns K-O were copied into columns P-T; they are labeled "Plan A" and "Plan B." The Macro buttons will need to be renamed. Also, after selecting the file, the macro writes the cell location on to cells S11-S13, this cell location might need changing.

Also attached is the data .txt file.

Thanks!!!

Habilidades: Excel, Visual Basic, Visual Basic para Apps

Ver mais: excel macro file location, visual basic applications vba macros workbook corrupted, visual basic net create excel file, convert visual basic file vba, finance visual basic macros, visual basic 2005 datatable excel, visual basic net read excel file access, vba excel spreadsheet work, simple visual basic application sort excel data, visual basic instalar add excel, visual basic code extract excel data

Acerca do Empregador:
( 0 comentários ) Bayonne, United States

ID do Projeto: #10498444

Premiar a:

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can make macro like your tab ideal Sir :) and it also can select 2 file txt file :) please give me a chance for doing this job and im able to start doing your job Mais

$105 USD em 1 dia
(227 Avaliações)
6.3

2 freelancers estão ofertando em média $103 para este trabalho

redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$100 USD in 2 dias
(80 Comentários)
5.2