Recording and troubleshooting the recorded macro:
- In the menu bar click on Tools
- Select Record a macro
- Accept the macro name and other details in the
new window record macro and click OK
- Now start entering the data. When finished,
click again on Tools in the meu bar and select Stop Recording
- Now select sheet2 and place your cursor in an
cell (D4). Click
on Tools and then Macros. From the new opened window select Run. The
recorde macro executes but the Name of the Item is in cell D4 and not
cell A1 as expected!
- Click on Tools, select Macro and then Macros...
andd finally Edit.
- In the Editor do a little tweaking as shown.
- Run the macro in sheet3.
- Everything works as expected and the data is in
the proper cells.
When you run the recorde macro, it doesn't behave as you expect. The
'Name of Item' in the macro appears where your cell selection was. This
is because the macro defined the first entry as ActiveCell, assuming it
to be the starting point in the macro! Now after tweaking the code of
the macro, the macro does exactly what you want it to do as shown in
the training video. |
|
|