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.
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.