If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Please Check Please Check New Rules for Download in Announcement Area.
Please Check for New Rules.
You may have to Click New Rules for Downlaod

Ask google "How to record macro in Excel" and try to record some simple macros (for automatic record). Then, after you have created macro, being in Excel window, press Alt+F11 and the window of Microsoft Visual Basic for Applications (VBA) would appear. Now you may see the macro you've just created. For in-depth understanding how macros work you will need some books or tutorials on VBA (Visual Basic for Applications) for Excel.
General technique in creating macros is recording the macro first (you make Excel to record your manual actions) and following editing the code for macro you have recorded.