Đang Thực Hiện

VBA macro for Excel

The goal of this marco is to copy some value from one sheet to another sheet with some conditions and logics.

Check the given file.

The marcro should do the following

- Clear all values from Sheet 'Import' in the cells with Row >=7 and Columns between Q column and Column for which the value is 'Total' for row 6).

- In sheet 'Arrivage', for each value in cell(A;i) (i from 2), lookup for similar value in the column B of Sheet 'Import', then update the cell value of this row in the column where its cell (in row 6) is equal to cell(0;i) from Arrivage. the cell should be updated with the Cell(C,i) from Arrivage Sheet.

Example :

The macro will check the code BD116 Cell (A;2) from Sheet 'Arrivage' and look in the Sheet import in the column B of sheet 'Import' => That would be row 8 (Cell(B;8)). Then update

- the cell(S;8) in Import with cell(C;2) from Arrivage

- the cell (U;8) in import with cell(D;2) from Arrivage

- the cell (W;8) in import with cell(E;2) from Arrivage

Note: sheet Arrivage can have 2 to n columns

Sheet Import can have 2 to n comumns between size and Total)

Kỹ năng: Visual Basic

Xem thêm: vba with, vba for, marco b, vba excel macro, vba e, row b, macro, Macro vba, macro excel, macro e, macro + excel, import excel, excel w, excel vba macro, Excel Macro VBA, excel 7, c# import excel, c import excel, vba excel copy, vba update excel, excel row column, excel macro row, excel copy vba macro, sheet excel visual basic, excel vba macro file

Về Bên Thuê:
( 20 nhận xét ) Paris, United Kingdom

Mã Dự Án: #1633476

Đã trao cho:

MDavidCrompton

Hi, Many thanks for the invite. You may have already checked my feedback. I will follow on with a completed file (possibly not today - its been a long one) and wait to hear from you. Thanks again David

$55 USD trong 1 ngày
(9 Đánh Giá)
3.8

26 freelancer đang chào giá trung bình $46 cho công việc này

Krusche

Hello. We are experts in Excel + VBA based projects. Have a glance at your PMB.

$60 USD trong 1 ngày
(23 Đánh Giá)
5.5
srinichal

let us discuss further

$120 USD trong 5 ngày
(28 Đánh Giá)
5.4
koolsidz

Excel Whiz here ;) Please see PMB

$45 USD trong 0 ngày
(42 Đánh Giá)
5.0
vserv

Excel expert. Pls check out my reviews. I specialize in Excel macros. Thanks

$30 USD trong 1 ngày
(28 Đánh Giá)
4.9
bouslimi1979

C'est déjà fait. Veuillez consulter mon message. Merci

$45 USD trong 0 ngày
(14 Đánh Giá)
4.7
northwolves

Ready to start,looking forward to working with you.

$35 USD trong 1 ngày
(33 Đánh Giá)
4.7
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi Thêm

$35 USD trong 1 ngày
(12 Đánh Giá)
4.3
ExactSystems

Please see a better solution on PMB. regards

$65 USD trong 2 ngày
(4 Đánh Giá)
4.1
ShiaFirst

I understood and can do this. Award the project.

$30 USD trong 1 ngày
(4 Đánh Giá)
2.9
monotoshroybd

Hello Sir, I am truly speaking to you that I able to complete of your task successfully within the time period with my expertise. Please find attached excel file as i was integrated web service for data transfer to Thêm

$30 USD trong 3 ngày
(2 Đánh Giá)
2.0
pradeep1210

Excel expert here. Please see PMB.

$40 USD trong 1 ngày
(2 Đánh Giá)
1.9
SilviaT

Please check PM.

$80 USD trong 1 ngày
(1 Đánh Giá)
1.2
forsameer

Quality is my first priority. This is my first project on freelancer, but I have a vast experience programming macro functions for MNC bank. Automation is like my passion. If you choose me for this project, you will be Thêm

$30 USD trong 1 ngày
(1 Đánh Giá)
1.2
gingy24

Have created macros which copy and sort sheet data, query it cell by cell to calculate figures. pretty fast.

$42 USD trong 3 ngày
(0 Đánh Giá)
0.0
Ophena

Hi, code ready...

$30 USD trong 0 ngày
(0 Đánh Giá)
0.0
chiefexec

Hello. I am an Excel expert and VBA programmer. I can help you with your project. Please contact me to proceed.

$30 USD trong 3 ngày
(0 Đánh Giá)
0.0
arntony

My Skills: VBA professional in a reputed firm || Work Experience: 8+ years || Please check your PM for project details

$42 USD trong 0 ngày
(0 Đánh Giá)
0.0
iamherein6

I have 10+ years in macro programming and surely give good output

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
fadeout79

I have a bachelor in computer programmation, excel macros have not secret for me.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
apcezar

I have finished your project

$40 USD trong 0 ngày
(0 Đánh Giá)
0.0