Đ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 nhiều hơn: tutorial top, tutorial n, top tutorial, top change tutorial, this n' that tutorial, this n that tutorial, this and that tutorial, excel opportunities, excel macro how to, bit tutorial, advanced ms excel, what is ms sql, what is macro in excel, vb in excel, work on ms excel, video tutorial, vb excel, macro, macro excel, macro + excel, excel to sql, excel macro advanced, excel advanced, create excel worksheet, create a tutorial video

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

ID dự án: #1897236