Completed

Excel Macro: reconciliation between 2 files

Hi

the work is to make an Excel macro

I have 2 files to reconcile A (1464335956...) and B (Gesamtauf....). There is a common field (file A:"Angebots-Nr." <-> file B:"Angebotsnummer"=) in the 2 files. I need:

o file A is a SW generated file.

- Certain rows (top, bottom) and columns shall be deleted,

- all num. fields must become numeric

- a new column ("geschickt zu MB") must be added

o into file A, when the common field is found in file B, the field "geschickt zu MB" must be ticked ("X")

that's it!

Compétences : Saisie de Données, Traitement de Données, Excel

en voir plus : macro excel cut paste columns, excel macro chart dynamic columns rows, summation columns macro excel, data entry, data processing, excel, excel macro convert columns rows, bank reconciliation macro excel, macro excel expense reconciliation, macro excel linking files, macro excel reconciliation, reconciliation vba excel macro, bank reconciliation vba macro excel, data entry macro, sw data entry

Concernant l'employeur :
( 8 commentaires ) VENTABREN, France

Nº du projet : #10621282

Décerné à:

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(53 Commentaires)
5.6

14 freelance font une offre moyenne de $22 pour ce travail

bouslimi1979

Bonjour, est ce qu'on peut discuter pendant 5 minutes pour clarifier des petits points. Je peux coder le macro dans 1-2 heures à partir de maintenant. Merci

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(230 Commentaires)
7.4
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of macros like this one and i've never had a single problem. If you are interested, can you resave this files and se Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(384 Commentaires)
6.7
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [login to view URL] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(149 Commentaires)
6.5
Slavuta

Hello! I have experience of over 20 years of working with EXCEL, VBA write programs of any complexity. If you need a macro to excel, i can do it. I need more information about your task.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(18 Commentaires)
4.4
abumusalilla

Hi, We knows value of quality and time. We humbly want to work with you with our honesty. We assure You that your project complete in time also within budget. Contact us! Thanks & Warm Regards Asif LILLA Computer Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(43 Commentaires)
4.5
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
4.1
delwar923

i can do this project ,i hope successful in this project please contact me as soon as early .............................................................................thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
3.0
kiptoofrank

A highly motivated and hardworking individual, who has recently completed their A-Levels, achieving excellent grades in both Maths and Science . interested in Commercial and financial markets. I am looking to further Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
arnoldnitin

I can write a VBA macro to compare and performance the functions you had asked..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
kislu72

CAREER PROFILE AND QUALIFICATIONS Twenty years of progressively responsible experience in the development and leadership of high-volume specialty pharmaceutical dispensing operations. Expertise in creating operating p Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Ruchi117

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
sonkusaurabh

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0