Đang Thực Hiện

151057 Excel Macro Tutorial

I am looking for someone to show me how to program a continuous macro in MS Excel. this is a little bit more advanced than average Macros .The whole process should be recorded via a screencam and be delivered to me as a video tutorial with sound, so i can create macros this way myself at anytime.

The Process:

1. The macro to run as a particular cell gets updated and check the value of that cell.

2. If the cell changes to a specified name/value, then the values from four adjacent cells to be taken and stored at the top of a table. As these values are stored in the table, the previous values in that row shift down one row, thus allowing the table to store maybe 100 rows with previous values.

3. There are cells called x,y and z on the worksheet. X is a changing value. The Macro should scan a column in the table and take the next value either higher or lower than X and place it in the cells Y or Z . As X moves beyond these values, either Y or Z values to change too, according to what is in the table.

4. There are two more cells with a name "BU" and "BD", the macro should also be able to recognise when specified cells are this value and then call up the value from a specified cell within the table.

This task should be very easy for someone who knows what they are doing. Opportunities for further work for the candidate in VB and excel will be available.

Kỹ năng: Bất kì công việc gì, SQL, Visual Basic

Xem thêm: tutorial top, tutorial n, top tutorial, top change tutorial, excel opportunities, bit tutorial, vb excel, macro, macro excel, excel macro advanced, excel advanced, create excel worksheet, c tutorial, bd, advanced excel, macros excel basic, excel row column, excel macro row, sql maybe, excel macro program, excel sql create, excel column row, excel cell, little sql, visual basic tutorial

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

Mã Dự Án: #1897236