How do you use Macros?

As you use Excel you do individual tasks using the keyboard and mouse For example "open workbook - insert new sheet -enter data - save etc. etc " Macros are a way to automate any routine or repetitive task by running these multiple instructions with one mouse click.You can make an Excel macro by going to :-

Tools --->Macro--->Record New Macro

You then use your keyboard & mouse to do whatever it is you want to automate and then save the macro.Once saved you can run the macro again ( and again) to repeat automatically what you previously did manually.

If you want to go further you can write your own macros using VBA Visual Basic for Applications which is fairly easy to get to grips with but inevitably involves a bit more time and effort.

A macro in computer science is a rule or pattern that specifies how a certain input sequence (often a sequence of characters) should be mapped to an output sequence (also often a sequence of characters) according to a defined procedure. The mapping process which instantiates a macro into a specific output sequence is known as macro expansion.

Visual Basic for Applications (VBA) is a programming language included in Microsoft Office and some other applications. However, its function has evolved from and replaced the macro languages which were originally included in some of these applications.

[edit] Macro virus

VBA has access to most Microsoft Windows system calls and executes when documents are opened. This makes it relatively easy to write computer viruses in VBA, commonly known as macro viruses. In the mid-to-late 1990s, this became one of the most common types of computer virus. Some applications with macro languages, such as OpenOffice.org, deliberately exclude certain functionality to avoid such susceptibility, though this should not present a problem to users.

A macro is just a set of pre-recorded, pre-defined instructions. Simply tell Excel to start recording a macro, do the tasks you want, stop recording, give the macro a name and that's it.

Tools, Macros ...

kind of, its all code stuff including vlookup, i found that cool

this will help you

http://www.taltech.com/support/sw_tricks/exmacros....